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.