Fixing Decimal places

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:


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

can you try this:

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

1 Like

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