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.