ChasW wrote:
Given the following statement:
SELECT * FROM tbl
WHERE [tbl].[column] IN ('a', 'b', 'c');
I want to be able to continue using IN so how could I change it so
that each of the values passed to IN are being handled as such:
'a' becomes LIKE "*" & "a" & "*"
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You can't use wildcards in the IN predicate. You'd have to use ORs:
WHERE tbl.column Like "*a*"
OR tbl.column Like "*b*"
OR tbl.column Like "*c*"
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRDw+KoechKqOuFEgEQJNFgCg6LRsG1YzZVoVckTM+Dt11P e9wG4AoPSj
kc9L4BB8r1gtLIIKu4yX0V/X
=mtEB
-----END PGP SIGNATURE-----