Binaryworld - Strip dirty characters from a numeric string. ... [ SQL Server -> T-SQL ]

A technique to search & remove dirty characters from a numeric string. This problem shows how you can simplify the solution by looking at only what is needed.

Click here to copy the following block

declare @dirty varchar( 6 )
select @dirty = '120-dd'
select convert( int ,
case when substring( @dirty , 1 , 1 ) LIKE '[0-9]' then substring( @dirty , 1 , 1 ) else '' end +
case when substring( @dirty , 2 , 1 ) LIKE '[0-9]' then substring( @dirty , 2 , 1 ) else '' end +
case when substring( @dirty , 3 , 1 ) LIKE '[0-9]' then substring( @dirty , 3 , 1 ) else '' end +
case when substring( @dirty , 4 , 1 ) LIKE '[0-9]' then substring( @dirty , 4 , 1 ) else '' end +
case when substring( @dirty , 5 , 1 ) LIKE '[0-9]' then substring( @dirty , 5 , 1 ) else '' end +
case when substring( @dirty , 6 , 1 ) LIKE '[0-9]' then substring( @dirty , 6 , 1 ) else '' end
) AS NumericValueOnly
/*
NumericValueOnly
----------------
120

*/