Codebase Expressions RIGHT() TRIM() - 08-13-2003 , 02:27 PM
I am attempting a query in codebase to query for a string that "Ends
In" a user specified string. i.e. 'Dilbert' would end in "ert"
Part of the expression that I am using is this(Assume NAME is an r4str
UPPER(RIGHT(TRIM(NAME),3)) = 'ERT'
In this example '3' could really be any number and 'ert' could really
be any text. The above expression however is unable to find
"Dilbert". If the expression is changed to
UPPER(RIGHT(TRIM(NAME),7)) = 'DILBERT'
then everything is fine and 'Dilbert' is found. I can also do the
UPPER(RIGHT(NAME,3)) = ' '
and all entries in the name table are found as they should be (since
NAME is padded with spaces at the end).
Why won't UPPER(RIGHT(TRIM(NAME),3)) = 'ERT' work?
I am using Codebase 6.5 for Windows CE. Thank you.
Re: Codebase Expressions RIGHT() TRIM() - 08-13-2003 , 02:53 PM
Well, it sure works in dBase IV...
I see no problem with the syntax...
"Ryan" avait écrit le 13/08/2003 :
(pour m'écrire, éliminez le _no_spam_ de mon adresse)