Page 1 of 1
Combining Firstname and Secondname When Searching
Posted: Fri May 06, 2005 10:13 am
by luketheduck
In an SQL SELECT statement, how do I combine FIRSTNAME and SECONDNAME, so that when I search for Bob Smith for example, it merges FIRSTNAME and SECONDNAME to produce the result I want?
Posted: Fri May 06, 2005 10:44 am
by Wayne
there are a couple of ways you could do something like that, but by the sounds of what you are trying to do look into CONCAT or CONCATENATE in your sql manual.
Posted: Fri May 06, 2005 10:52 am
by onion2k
Wayne wrote:there are a couple of ways you could do something like that, but by the sounds of what you are trying to do look into CONCAT or CONCATENATE in your sql manual.
And CONCAT_WS if it's mysql..
Posted: Fri May 06, 2005 12:04 pm
by luketheduck
Sorted. Cheers for that.