Use this
SELECT Firstname,Lastname FROM Names WHERE (Firstname='Trausti Thor'
AND Lastname 'Johannsson') OR (Firstname='Trausti' AND Lastname 'Thor
Johannsson')
You have to construct the SQL statment in order to match all the
combinations you think people can make witj your name
Good look
Rafael Vallejo
http://www.goldwaresoft.com
Trausti Thor Johannsson escribió:
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>
_______________________________________________
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>
