Hi Friends,

Facing a problem with a simple query.
I have a table T1 having 4 fields, fld4 C(4) has two sets of value 'S'/'SP'

Now when i run a query
Select * from T1 where fld4 <> 'S'

I expect it to return me rows having fld4 values as 'SP' but it doesn't.
My environment
SET ANSI OFF
SET EXACT ON

Am i going wrong in such a small query... I must be over worked . I guess.
Thanks.