Converting varchar to decimal in sql server 2008

I have this data as varchar '00072330'. How do I convert it 开发者_如何学Pythonto a decimal that looks like '723.30' in SQL Server 2008?

Try this:

declare @data as varchar(8)
set @data = '00072330'
print cast(@data as decimal) / 100

This:

SELECT CAST('00072330' AS INT)/100.0

...will give you:

723.300000

The .0 is important, otherwise SQL Server will perform integer math.