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.