hi all, i need to filter from mytable all records have value 2007, myfield character type(c 20) as (January 2007 ),
as
SETFILTERTO dat=SUBSTR("January 2007 ",8)
select * form mytable where dat = SUBSTR("January 2007 ",8)
or
SELECT * FROM newtable WHERE dat=RIGHT(" 2005 ",14)