Use of Like within in opertor in WHERE clause

[moon-ray]

I am building an SQL statement from selections in a form. One of the options on the form is address field. The field to specify the address is a multiple selection listbox. Because of the structure of the address, I need to use the LIKE operator. I have good code to use the IN operator. What I tried was "=In(Like "*31*", Like "*70*")" but it does not work. If I use just the values in the In( ), it works with missing the where those strings are in the list. If I use the Or operator with the Likes individually listed, it works. It just won't work. Is there a way to make this work.



Thanks, in advance

[ItsMe]

I have never tried wildcards with the IN operator. Don't think it will work. An SQL statement using the IN operator would look like this.

SELECT MyTable.Field
FROM MyTable
WHERE MyTable.Field IN ('foo', 'bar', 'baz')

So if wildcards were acceptable it would be like this ...

SELECT MyTable.Field
FROM MyTable
WHERE MyTable.Field IN ('foo*', '*bar*', '*baz')

I did a quick little search and I think the best solution is to use the OR operator. Another approach might be a UNION as explained in answer #39 here ...
http://stackoverflow.com/questions/1...for-sql-server

[June7]

Also review http://allenbrowne.com/ser-50.html

Use of = sign with IN is certainly not appropriate.

[orange]

moonray,

I suggest you give us a more detailed description of what you are trying to do, and a sample of your data (the raw address data) and a corresponding desired result(based on that raw data).