Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 31, 2012 03:00 PM by dattatraya.kale
May 31, 2012 02:52 PM|LINK
There are two fields in the table which is FirstName and LastName. For example:
How can I find this record if user inputs the search criteria as "Michael Jorden"? Thanks in advance
May 31, 2012 03:00 PM|LINK
SELECT * FROM Table WHERE FirstName + LastName LIKE '%Michael Jorden%'.
But this will have some performance issue.