Compare numeric strings with leading zeros

[J. Landman Gay]

Ralph DiMola wrote:
>
>Feeling pretty clueless here but...
>
>I need ("5" = "005") to be false. This is for password validation.

I could swear this used to work using some tricky combination of < and 
 >. Anyway, the trick is to make them compare as strings. Forcing 
quotation marks seems to work:

   put quote & "5" & quote into tFirst
   put quote & "005" & quote into tSecond
   put tFirst = tSecond

-- 
Jacqueline Landman Gay         |     jacque at hyperactivesw.com
HyperActive Software           |     http://www.hyperactivesw.com