RegExLib.com - The first Regular Expression Library on the Web!

Please support RegExLib Sponsors

Sponsors

Expressions by User

   Displaying page 1 of 1 pages; Items 1 to 1
Title Test Details Pattern Title
Expression
^[a-zA-Z_]{1}[a-zA-Z0-9_@$#]*$
Description
This Regex matches valid SQL identifiers, including names for Stored Procedures and the like. Note that local variables/parameters (which begin with an "@") will not match this Regex, nor will temporary objects (beginning with a "#"), or global temporary objects (beginning with "##"). All other valid identifiers/variables/table names/stored procedure names/columns etc., will match. Please let me know if you find this useful or have any complaints - [email protected].
Matches
upApplicationReadContacts | _Application_ReadContacts | a_45$#z
Non-Matches
upApplication ReadContacts | $Application_ReadContacts | a_45%$#z
Author Rating: The rating for this expression. Geoff Williams
   Displaying page 1 of 1 pages; Items 1 to 1

Copyright © 2001-2024, RegexAdvice.com | ASP.NET Tutorials