How about:
SELECT *
FROM myTable
WHERE myField IN ('#myString#')
> -----Original Message-----
> From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 22 January 2003 11:26 a.m.
> To: CF-Talk
> Subject: String matches
>
>
> If I have a string that can contain one or more entries, and
> I want to
> match it against a table field, what's the best CF5 way of doing
> this? The string MAY have a comma, but if only one entry is
> in it there's
> no comma...
>
> For Example, if my string is:
>
> <CFSET MyString="MA32-30443,20WQ11,4055392T5">
>
> OR if my string is:
> <CFSET MyString="39EUWI33">
>
> how do I compare that to a datatable that would possibly have
> at least ONE
> of the entries in the string?
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
