srikant maurya (2/6/2011)
this may help if you Ignore only first number char from Strselect * from Table where isnumeric(left(column_name,1))=0
Oh, be careful now. IsNumeric shouldn't be used as a digit test. Please see the following article on that, please...
http://www.sqlservercentral.com/articles/IsNumeric/71512/
--Jeff Moden
Change is inevitable... Change for the better is not.