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 ) set @s = 'as4khd0939sdf78' set @result...