Convert a string field with pennies into a dollar amount with 2 decimal places in SQL Server.

Question

I have a field in a table as nvarchar(10), which is used to store a value in pennies. For example, $23.50 is stored as "2350".

I need to return this value to the program in Money format. How would I do that in the Select statement?

Answer 1

 cast(cast (pennies as numeric(16,2))/100 as money)

Answer 2

Select convert(money, field/100, 0) from table

Answer 3

SELECT CAST (IntAmount / 100.00 as MONEY)