SELECT CONVERT(decimal(8,4),REPLACE(@B, '%','')) / 100;
--Or, if you want ANSI SQL
SELECT CAST(REPLACE(@B, '%','') AS decimal(8,4)) / 100;
Edit: Best practice, store your Percentage values as decimals, and then have your presentation layer worry about the formatting (hopefully this is the intention behind your question, 🙂 )
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk