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
Bill Jaynes [ Sa, 01 Dezember 2007 19:10 ] [ ID #1883525 ]

Re: Text comparison in FMP5

bjaynes [at] montanaport.net <bjaynes [at] 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
jrijnb [ Sa, 01 Dezember 2007 20:19 ] [ ID #1883526 ]

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... [at] xs4all.nl (Hans Rijnbout) wrote:
> bjay... [at] montanaport.net <bjay... [at] 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
Bill Jaynes [ Di, 04 Dezember 2007 21:26 ] [ ID #1885328 ]

Re: Text comparison in FMP5

bjaynes [at] montanaport.net <bjaynes [at] 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... [at] xs4all.nl (Hans Rijnbout) wrote:
> > bjay... [at] montanaport.net <bjay... [at] 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
jrijnb [ Mi, 05 Dezember 2007 00:57 ] [ ID #1886216 ]

Re: Text comparison in FMP5

Thanks Hans,
I appreciate your help with this.
Bill

On Dec 4, 4:57 pm, jri... [at] xs4all.nl (Hans Rijnbout) wrote:
> bjay... [at] montanaport.net <bjay... [at] 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.
Bill Jaynes [ Mi, 05 Dezember 2007 03:58 ] [ ID #1886219 ]
Datenbanken » comp.databases.filemaker » Text comparison in FMP5

Vorheriges Thema: Ridiculous problem : getting FM to talk to Access
Nächstes Thema: Age Calc Help please