Re: Simple contains query question

2003-10-24 Thread Egor Egorov
Dale Hans <[EMAIL PROTECTED]> wrote: > I have a field in the table, call it 'stuff', and it contains a list > of values that are comma separated. i.e. 'Books,DVDs,Video > Tapes,CDs' > > I want to SELECT out all records that have an item. I know IN works > the other way, so is there something

Simple contains query question

2003-10-23 Thread Dale Hans
I have a field in the table, call it 'stuff', and it contains a list of values that are comma separated. i.e. 'Books,DVDs,Video Tapes,CDs' I want to SELECT out all records that have an item. I know IN works the other way, so is there something that will get what I want like this: SELECT * FROM