Convert varchar to number

SQL Server Administration
1

I want to convert 1250 to 12.50 how to do make it sql script.

2

CAST(YourVarcharString as FLOAT)/100.0

3

CAST(column_name / 100.0 AS decimal(9, 2))

4

Hi ScottPletcher / James,

Thanks for your prompt reply. this script works perfectly. this what i was looking. Thanks a lot.