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

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 .

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