Searching string data field, returning entire record(s)

[mtndew]

Hi, I'm stuck. I've been trying to search a field in a database that has a string like this one; "01, 02, 03, 04, 05". Some records, over 20,000, will have one number, some more than one number, most have different assortment. I need to be able to find records where the value in that field equals one or more of those numbers, pull that record and put it into a report.
I have been able to get it using various string functions such as InStr() and Split(), but these reqiure a single dimensional array, as such the key number field for the record is not available in order to grab that record. It would be if this could be a two dimensional table.
Can anyone offer a suggestion, somewhere to go perhaps so that I can figure out an answer?
Thanks much in advance. mtndew

 

[bangalibhai]

Use the "like" pattern matching operator in your SQL query to search a certain field(s) of a table.

 

[mtndew]

That did it...May you live a thousand lives my friend mtndew