Date:         Thu, 10 Jan 2008 09:58:38 -0500
Reply-To:     Muthia Kachirayan <muthia.kachirayan@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Muthia Kachirayan <muthia.kachirayan@GMAIL.COM>
Subject:      Re: test character string for certain format
Comments: To: Takeadoe <mtonkovich@msn.com>
In-Reply-To:  <271feebd-4fe6-4f67-87a9-9600f531bb2c@j78g2000hsd.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

You can use

ANYDIGIT() and NOTDIGIT() functions.

Muthia Kachirayan

On Jan 10, 2008 9:00 AM, Takeadoe <mtonkovich@msn.com> wrote:

> Good morning,
>
> I've got a field that is supposed to contain Ohio driver's licenses.
> All Ohio DL are of the following format AANNNNNN - two letters
> followed by 6 numbers.  This field contains values such as 0, 00T8,
> and of course valid DLs such as RK678901.  Can some one help me figure
> out how to classify each record as valid or invalid based on these
> criteria?
>
> Thank you very much!
>
> Mike
>