Hi,
  i am fairly new to RegExp's. I was wondering how i might be able to 
check for the occurence of only an alpha character eg abcdefg..z in a 
string/field?

Thanks in advance for your help.

Set your pattern to "[a-zA-Z]" (or \w if you also want to include numerics)

Test your string against the pattern.  Test will return true if there's a
match, 
otherwise it will return false.

The above assumes you are somewhat familar with the RegExp object provided
in 
VBScript.  If not, here's a fairly good overview:

http://msdn.microsoft.com/library/en-us/dnclinic/html/scripting051099.asp?fr
ame=true

******************************
Jack Speranza
Gryphon Networks
Automating Privacy Compliance for Business
xxx.xxx.xxxx  x129
www.gryphonnetworks.com

"Software never has bugs.   It just develops random features."



-----Original Message-----
From: imran.saleem@b... [mailto:imran.saleem@b...]
Sent: Thursday, December 19, 2002 12:09 PM
To: ASP Databases
Subject: [asp_databases] checking for chars a-z in field


Hi,
  i am fairly new to RegExp's. I was wondering how i might be able to 
check for the occurence of only an alpha character eg abcdefg..z in a 
string/field?

Thanks in advance for your help.