[thelist] SQL (or ASP?) selecting from a multi-valued column

Elfur Logadottir elfur at lists.evolt.org
Mon Feb 5 16:55:40 CST 2001


From: "Luther, Ron" <Ron.Luther at COMPAQ.com>


| ummm .... What kind of strange things do you get back when
you try
|
| Select * from table where field_we_care_about = 1;

this: "Data type mismatch in criteria expression"

| I'm guessing you tried these first and they didn't give
you what you wanted.

Yes I did, thank you, and the thing is, that the value of
the column is = 1 it's = 1,2,4,5,11 etc.

so obviously it wouldn't work (me thinks, but it doesn't
mean that it's obvious to anyone else)

thanks
elfur





More information about the thelist mailing list