Converting varchar to decimal in sql server 2008

Question

I have this data as varchar '00072330'. How do I convert it to a decimal that looks like '723.30' in SQL Server 2008?

Accepted Answer

Try this:

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

Solution