SQL Server - How to get the non-numeric values in a sql column ?

Asked By The Hunk on 16-Jun-12 07:58 AM
hai

i am using the below code to get all numeric values into one table
set @sql8=N'insert into #ExcelTempTable1 SELECT Isnumeric('+@ofieldname+') as F1, '+@ofieldname+' as F2 FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;HDR=Yes;IMEX=1;Database='+@oFilePath+''', ['+@osheetname+'])'

in the above Column F1 get 1 and column F2 get mobile number .

in the same way how can i get all non-numeric values into a table, Column F1 get 0 and column F2 get mobile number .
S K replied to The Hunk on 18-Jun-12 03:04 AM
See this thread to write a function that will check all non-numeric value in column of table in sql server
http://www.dbasupport.com/forums/showthread.php?t=40890 

hope this helps you