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?
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.
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.