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

• • Reply
  

  wong0630

  Member

  10 Points

  25 Posts

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

  May 31, 2012 02:52 PM|LINK

  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

• • Reply
  

  dattatraya.k...

  Member

  150 Points

  32 Posts

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

  May 31, 2012 03:00 PM|LINK

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

  But this will have some performance issue. 

  Please mark as answer if this post answered or solved your problem.
  
  Thanks and Regards,
  Dattatraya Kale.
  • Marked as answer by wong0630 on Jun 01, 2012 04:17 AM