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?