Wow... You guys are really great!

I used your example, and it worked perfectly!

select distinct chips, salt --, date

from SNACKS

where SNACKS .salt= 'No'

AND chips NOT IN(select distinct chips...

prima! outstaken!

is ok... is a very small db.

let me see what i can do with these examples.

thanks to all!

🙂

thanks for the replies... the value

i gave was just a sample not the actual results coming out of the query.

and it wouldn't be just 'that' value; would be...

Gsquared... that did the trick!

you guys really know your craft! THANKS!!

we are getting alot closer.

i simply replaced the -1 with -0

the columns are both there, and string has been separated, but... the comma (,) remains

on the end of col1, but...

thanks again gsquared.

really grateful of your help, and especially since the code is getting alot shorter.

ran the script, but getting the SUBSTRING error again.

just did some reading up...

thanks for the good explanation of everything! 🙂

hopefully just one more question, and i will be done.

according to your example ( which is much easier to read ) than my...