>If you are doing the SELECT through a native driver, it should work as is, but if you are using SQLPassthrough, try making sure your cases match. Native Oracle is not case sensitive, but some driver for it are.
> ie SELECT * FROM OWNER.TABLE tablea WHERE tablea.SEX = 'M' vs
> SELECT * FROM OWNER.TABLE tablea WHERE TableA.SEX = 'M'
>
>Another thing is to rember that string literals are in single quotes ' (rside of the = ) while tables, fields etc are in double quotes "
>i.e. "_SMDBA_"."Open Calls" o_calls WHERE o_calls."Open Date" = '01/02/200'
I missed his double-quotes around the M. That would be his problem. Use single quote mark instead.
Mark McCasland
Midlothian, TX USA