Browse by Tags

All Tags » Extract numbers » T-sql (RSS)

Extract only numbers from a String

Sometimes we may need to extract only numbers from a string. Usually I see people using while loop to check each and every character to see if it is a number and extract it Here is a different approach Declare @s varchar ( 100 ), @result varchar ( 100...