>That works.
>
>Is something wrong with my query??

When you use SQL, if Ansi=off, then 'SS'='S'. Set Ansi is the same as Set exact, only Ansi is for SQL.

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