How to pass concatenated multiple column value as the search condition

Hi,

I'm using SQL Server 2008

I have concatenated values of two columns(Firstname and lastname) of a table(Person). I want to retrieve all the values based on this names.

I have used this query

SELECT * FROM Person WHERE FirstName+LastName LIKE '[RijoVarghese%]';

where Rijo is the value of the column Firstname and Varghese is the value of LastName .

Thank you in advance.

March 24th, 2015 2:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics