Hi all,

I have a text field that contains a list of IDs e.g. 16,20,24,29,38,40

I need to find any records where that field contains a particular ID.

I thought that something like SELECT * FROM tablename WHERE IDlistfield CONTAINS myID but that doesn't work.

Can anyone point me in the right direction?

TIA

Tom