Query combining two fields
Posted: Wed Oct 19, 2005 4:00 pm
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)%'
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)%'