SQLTeam.com | Weblogs | Forums

Fixing Decimal places


#1

I have a stored procedure which reads a raw table (all nvarchar) and inputs into a new SQL table

My new table requires a field to have 2 decimal numbers, but at the moment I just use the following:

convert(float,file_a.Amount)

This is returning only whole numbers where there are no decimal places. I know that I need to use the CAST command, but struggling

Many thanks


#2

can you try this:

CAST(file_a.Amount AS DECIMAL(18, 2))


#3

You do not have "12345" but want "123.45"?