Alphanumeric and Special Character Validation

Inspired in the script submited by ramesh_kondaparthy , this is a set oriented solution for the same problem.Parameters: 1) @InputString varchar(25)Accepts the string, which we need to validate 2) @Type int = 0 validate the string for only alphanumeric charactersi.e Allows characters between [A-Z] ,[a-z] and [0-9] = 1 validate the string for alphanumeric and […]

2006-08-22 (first published: )

689 reads

Blogs

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

I’m Speaking at #SQLSatSpokane

By

I am super excited to announce that I have been selected to speak at...

Common commands and tasks to make dealing with Windows Core easier.

By

I don’t know how many of you are working with Windows Core these days...

Read the latest Blogs

Forums

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2

By Ginger Keys Daniel

Comments posted to this topic are about the item Move Data from SQL Server...

Knowing What You Don’t Know

By Grant Fritchey

Comments posted to this topic are about the item Knowing What You Don’t Know

Automate Import of LIBOR Rates

By Phil Parkin

Does anyone have any recommendations for sites which publish the daily LIBOR rates in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers