SQLTeam.com | Weblogs | Forums

Convert varchar to number


#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.