Page 1 of 1

Query combining two fields

Posted: Wed Oct 19, 2005 4:00 pm
by jwalsh
Hi,

Is there a way using SQL to query WHERE a keyword is LIKE 2 fields combined?

ex.

SELECT * FROM testtable WHERE 'mysearch' LIKE '%(fielda CONCANTENATED WITH fieldb)%'

Posted: Wed Oct 19, 2005 4:30 pm
by timvw

Code: Select all

SELECT *
FROM table
WHERE CONCAT(name, ' ', surname) LIKE 'Van Wassenhove T%'

Posted: Wed Oct 19, 2005 4:33 pm
by jwalsh
Awesome! haven't tried it yet, but knowing Timbo, it will work like a charm.

Thanks! Didn't know about CONCAT