Subject Re: filter
From Milind Nighojkar <milinigh@yahoo.com>
Date Mon, 02 Aug 2021 01:39:14 -0400
Newsgroups dbase.getting-started

use this syntax to set filter to the records having the first number in the field to be "1"

set filt to at('1',fieldname) = 1


Milind Nighojkar Wrote:

> Hello Moses,
>
> Try this...
>
> If your field name is 'fieldname' then the syntax will be
>
> set filt to at('1',fieldname) > 0
>
> Regards
>
> Milind Nighojkar
>
>
>
> Moses Hanna Wrote:
>
> > Hi
> > 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
>