>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.

Try

Select * from T1 where not fld4 == 'S'