Text comparison in FMP5

Hello,
I am using the = operator to check to text fields for being the
"same". As I run this, it appears that this comparison is not case
sensitive. Does that jibe with what others know?
aB5 appears to equal AB5
Thanks,
Bill

Re: Text comparison in FMP5

bjaynes@montanaport.net wrote:

> Hello,
> I am using the = operator to check to text fields for being the
> "same". As I run this, it appears that this comparison is not case
> sensitive. Does that jibe with what others know?
> aB5 appears to equal AB5

If you want an exact match, you can use the function "Exact(textfield1,
textfield2)" instead of the equals sign.

--
Hans Rijnbout
Utrecht, Netherlands

Re: Text comparison in FMP5

Thanks Hans,
Are you then saying that without applying "Exact", ab5 does equal AB5?
Bill
On Dec 1, 12:19 pm, jri...@xs4all.nl (Hans Rijnbout) wrote:
> bjay...@montanaport.net wrote:
> > Hello,
> > I am using the = operator to check to text fields for being the
> > "same". As I run this, it appears that this comparison is not case
> > sensitive. Does that jibe with what others know?
> > aB5 appears to equal AB5
>
> If you want an exact match, you can use the function "Exact(textfield1,
> textfield2)" instead of the equals sign.
>
> --
> Hans Rijnbout
> Utrecht, Netherlands

Re: Text comparison in FMP5

bjaynes@montanaport.net wrote:

> Thanks Hans,
> Are you then saying that without applying "Exact", ab5 does equal AB5?
> Bill

Yes, as you found out. However, if in the field definition options under
"storage" you specify ASCII as the indexing language, you may change
this behavior.

> On Dec 1, 12:19 pm, jri...@xs4all.nl (Hans Rijnbout) wrote:
> > bjay...@montanaport.net wrote:
> > > Hello,
> > > I am using the = operator to check to text fields for being the
> > > "same". As I run this, it appears that this comparison is not case
> > > sensitive. Does that jibe with what others know?
> > > aB5 appears to equal AB5
> >
> > If you want an exact match, you can use the function "Exact(textfield1,
> > textfield2)" instead of the equals sign.

--
Hans Rijnbout
Utrecht, Netherlands

Re: Text comparison in FMP5

Thanks Hans,
I appreciate your help with this.
Bill

On Dec 4, 4:57 pm, jri...@xs4all.nl (Hans Rijnbout) wrote:
> bjay...@montanaport.net wrote:
> > Thanks Hans,
> > Are you then saying that without applying "Exact", ab5 does equal AB5?
> > Bill
>
> Yes, as you found out. However, if in the field definition options under
> "storage" you specify ASCII as the indexing language, you may change
> this behavior.