Partial matches in SQL Search

Is it possible to preform a sql query that could have partial matches..

For instance:

I have a field called zipCodes with entrys of
"777 555 888"
"555 222 111"
"333 444 555"

and I want to do a search for all entries that have the area code 555 in it.

Or even in the case of how a basic search would function looking for text.

Thanks,

Jesse

You would need to use the LIKE comparison in your SQL query. So:

SELECT *
FROM table
WHERE zipCodes LIKE '555%';

The percent sign is the wildcard symbol for many characters - for a single character use the underline (_) character.

SELECT * FROM table WHERE zipCodes LIKE '555%';
==> 555 222 111

SELECT * FROM table WHERE zipCodes LIKE '%555%';
==>
777 555 888
555 222 111
333 444 555

SELECT * FROM table WHERE zipCodes LIKE '%555';
==>
333 444 555

reg
kevin

Thanks!

could u mark this resolved, there is a link below, thanks

reg
kevin