Searching two fields as if they were one

[cmwslw]

I have two fields in my database called fname (first name) and lname (last name). I was wondering if there was a way where I could search as if they were just one field that had both first name and last name so searches like 'Bob Smith' would turn up. I already tried having "WHERE CONCAT('lname', 'lname') = searchterm", but it didn't work. Any suggestions or will I just have to make another field that has both put together?

[chazzy]

did you try...


select columns...
from your_table a
WHERE CONCAT(a.fname,' ',a.lname) LIKE '%search term%';


?

[cmwslw]

That worked great! Thanks for the fast reply.

-Cory Walker