Subject Re: filter From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Mon, 2 Aug 2021 14:02:48 +0530 Newsgroups dbase.getting-started Good Afternoon Moses, Milind, > > If your field name is 'fieldname' then the syntax will be > > set filt to at('1',fieldname) > 0 > >> I have a field with character numbers such as "121008" >> I want to set filter to the records having the first number in the field to be "1" >> what will be the code line >> please help >> I am using dbase 2.7.0.2 at() will not work here as at() will return a positive number even when 1 is at any other position. The function that will help here is left(fieldname,1) = '1' Moses If the above does not help you then you will have to tell us how you are accessing the data xdml or oodml Will b able to give specifics then only. Regards Akshat