>hi all,
>i need to filter from mytable all records have value 2007,
>myfield character type(c 20) as (January 2007 ),
>
>as
>
>SET FILTER TO dat=SUBSTR("January 2007 ",8)
>select * form mytable where dat = SUBSTR("January 2007 ",8)
>or
>SELECT * FROM newtable WHERE dat=RIGHT(" 2005 ",14)
>
>thanks.
SET FILTER TO "2007" $ dat
GO TOP
OR
SELECT * FROM newtable WHERE "2007" $ dat
_______________________________________________________________
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