Saturday, August 6, 2011

Retreive only Alpha numeric values in TSQL

Suppose we have a column in a database which containse numeric, alpha-numeric or alpha . Following query can be be used to retrieve only alphanumeric fields:

Sample:

Select * from tblUser Where Name like '%[0-9]%'
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

If you’re using Visual Studio to build your .NET MAUI app on a Mac, locating the IPA (iOS App Package) file can be a bit tricky

  If you’re using   Visual Studio   to build your   .NET MAUI   app on a   Mac , locating the   IPA (iOS App Package)   file can be a bit tr...