How can I search the record if I the first name and last name is combined together?

Hi,

There are two fields in the table which is FirstName and LastName. For example:

FirstName LastName

Michael Jorden

How can I find this record if user inputs the search criteria as "Michael Jorden"? Thanks in advance

Re: How can I search the record if I the first name and last name is combined together?

SELECT * FROM Table WHERE FirstName + LastName LIKE '%Michael Jorden%'.

But this will have some performance issue.