Home Forums SQL Server 7,2000 T-SQL Urgent! - How to extract number from a string RE: Urgent! - How to extract number from a string
Avaneesh -388582
SSChasing Mays
Points: 657
More actions
November 18, 2007 at 10:19 pm
#752141
Hi,
You can try the following query :
select case isnumeric(YourFieldName) when 1 then YourFieldName else 0 end.
Hope that Helps 🙂