Two fields become one?!

Results 1 to 2 of 2

Thread: Two fields become one?!

  1. #1
    Join Date
    Dec 1969

    Default Two fields become one?!

    Hi, I have a pretty normal table with info about actors. I have one field named firstname and an other field named lastname. In my query I would like to put these two fields together and compare with a search string, something like this<BR><BR>WHERE (firstname & lastname) LIKE &#039% string %&#039 If there is no way to do this, how am I going to make the search function?<BR><BR>Thanks in advance/Fredrik

  2. #2
    InstrRev Guest

    Default RE: Two fields become one?!

    select FirstName+&#039 &#039+LastName from thisTable<BR>Where FirstName+&#039 &#039+LastName Like &#039%myString%&#039

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts