Hi Nancy.

I dont know where I got the 'IN' from but I thought you could use it as a VFP $ type function in SQL. I tried Cetins code and it worjed fine.

Regards,

Gerard


>Gerard-
>
>>I am getting an oledb exception error in a elect where clause
>>
>>string cStr;
>>cStr = cString.ToLower().Trim();
>>this.sSelectString = "SELECT " + this.sFields + " FROM " + this.sTableName +
>> " WHERE cStr IN isr_name ";
>>
>>Im sure the problem is in the 'Where' syntax command as it selects all records
>> into the dataset ok if I take the Where Bit Out.
>
>There is no IN clause as you're using it. I agree with Cetin's interpretation of your goal, but just for jollies, could it be INLIST() that you're thinking of? IIRC, you're using Fox as the backend.