How to retrieve records that have a field with multiple values? 1

[notageek7]

I've got a combo box change event that requeries a listbox. My problem is the sql statement works fine to display all records that match the combo box value when the records field is a single value (like that in the combo box). My problem is I've inherited a database that has records with fields that have multiple values in them. For example, a field named error codes can contain numerous error codes. So an order can have 'MD03,MD42,CP12' in it's error code field. What is the best way to look through the records and populate the listbox with all records with a particular error code, so the listbox would also include those records that have multiple error codes? Sorry for the long confusing question.

 

[alvechurchdata]

Can you use "LIKE *MD03*" in the SQL WHERE clause?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[notageek7]

Thank you, I'm currently learning more options with sql.