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]%'

No comments:

Post a Comment

LIveCharts2: Charts for Windows and web

Charts for Windows and web including .Net MAUI  LiveCharts - LiveCharts2 (lvcharts.com)