Combination of columns in where condition

Question

I have a clarification in SQL where condition, how do I use multiple columns combination in where conditions?

For example:

select *
from employees
where employee_firstName+employee_lastName = @emp_FirstName+@emp_LastName

I want the combination of the two parameters together.

I am using Sybase. Can anyone help me please?

score 3 · Accepted Answer · edited Sep 19 '11 at 06:52

3

I can't test it, but should work faster:

select *
from employees
where employee_firstName = @emp_FirstName
  and employee_lastName  = @emp_LastName

edited Sep 19 '11 at 06:52

mu is too short

answered Sep 19 '11 at 06:48

Alexander Molodih

maialithar · Answer 2 · 2011-09-19T06:57:30.820

1

you should use concatenation operator, as described here:

select *
from employees
where (employee_firstName+employee_lastName) = (@emp_FirstName+@emp_LastName)

edited Sep 19 '11 at 06:57

answered Sep 19 '11 at 06:49

maialithar

Thanks Alexander and maialithar, Its worked for me, i tried with (employee_FirstName+employee_LastName) = (@emp_FirstName+@emp_LastName) .. Working Fine .. Thanks realy helpful for me!!!!! guys.. – Nagarajan Sep 19 '11 at 07:10
Not only this is non-sargable, but it can also return unexpected rows. For instance, if you searched for `Mariah Olbert`, you might additionally get `Maria Holbert`, and vice versa. – Andriy M Sep 19 '11 at 09:16

2 Answers2