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:


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

No comments:

Post a Comment

Your project is not referencing the "MonoAndroid,Version=v8.1" framework. Add a reference to "MonoAndroid,Version=v8.1" in the "frameworks" section of your project.json, and then re-run NuGet restore.

I had  the same problem. Reason: file obj/project.assets.json target "MonoAndroid,Version=v7.1" when my project target androi...