Text to float or decimal conversion

I need a help in开发者_JAVA技巧 SQL query .

i have a table like

A | B | C

1 | 1.3 | p

2 | 2.6 | c

fields (A- type int) (B--type(text)) (C-Type(nvarchar))

i need to multiply (some value with (B type(text)) example (1.3 X b)) as x is it Possible .

please let me know

From MSDN CAST and CONVERT :

Try something like this :

SELECT CONVERT(decimal(10,5),(CAST(B AS varchar(10)))) * MyValue 
AS MyMultipliedValue FROM TABLE