Re: SQR command to distinguish alpha characters from aplha-numer

[Juan José Breuer Moreno <jbreuer@UNIFAX.COM.AR>]

Perhaps a fast one could use the translate to change de 0123456789 to
##########
and the compare the old value with the new one. If there are equal then it's
alpha only.

Let $test = translate($string, '01234567890', '##########')
If $test = $string
    ! Alpha
else
    ! Alphanumeric or numeric.
End-if


----- Original Message -----
From: Zubin Shroff <zshroff@DTTUS.COM>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Sent: Monday, July 12, 1999 7:49 PM
Subject: SQR command to distinguish alpha characters from aplha-numer


>      Is there an SQR command that can be used to interrogate a field and
>      determine whether all characters are alphabets or alpha-numeric?
>
>      e.g. Given 2 field values of 'JOB' and 'JOB9', we need to determine
>      that JOB is alpha-only and JOB9 is alpha-numeric.
>
>      Just wondering if there is an easier way than to read each character
>      and look for the first non-alpha character
>