Nando Dessena wrote:

> Lee,
>
> L> SELECT Field1, Field2 FROM MyTable WHERE 'ConstantValue' IN Field1;
>
> what does Field1 contain? A single value? A list of values? An array?
> Please give example data and result you wish to get.
>
> Ciao

Thanks Nando,

More than likely, VarChar(250);


--

Warm Regards,

Lee