I have a little problem.

I have a database with Firstname and Lastname. How do I combine them to search for full names ?

For example, take my name,

Firstname = Trausti Thor
Lastname = Johannsson


How would I search for "Trausti Thor Johannsson" ?? Remember, some people might have entered the data like this :

Firstname = Trausti
Lastname = Thor Johannsson


So I need to combine the fields somehow. And need to do this with one sql select statement.


Best regards,


Trausti
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Reply via email to