>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 This
Select * from T1 where "SP" $ UPPER(fld4 )
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst