Convert a varchar to decimal

[Dineedshelp]

ARGH!!!!

I have tried and tried with this and probably the answer is staring me in the face!!!!

I have a field call hrs_worked,varchar(5) and basically holds the number of hours a person has worked. I need to convert this figure to a decimal figure.

I have tried a combination of cast and convert functions and nothing appears to work!!!

Please help!!!!!!

 

[jby1]

This worked for me, I think it is doing what you want:

declare @vc varchar(5)
declare @d decimal(5,2)

select @vc = '10.11'

select @d = convert(decimal(5,2), @vc)

select @vc,@d

Output
10.11 10.11

 

[jby1]

In fact you don't even need the convert!

declare @vc varchar(5)
declare @d decimal(5,2)

select @vc = '10.11'

select @d = @vc

select @vc,@d

Output
10.11 10.11

 

[sneki]

SELECT CONVERT(decimal(10,5), columnName) from tableName