One more question ,Ask about SQL ?

Posted by Tien Ho Van on September 13, 2000 at 11:15:48:

Hi ! I want to use SQL command to filter range of records
i.e to get all records from record number 4 to 10 in my table , I coded as:
Select * from mytable A where A.recno > 4 and A.recno<10
I get message "Invalid field name recno "
So how can I write to let Delphi know Recno is a function not a field ?
Thanks !