format reals output - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

format reals output

Author

Topic

vesben
Starting Member

7 Posts

Posted - 2013-10-15 : 12:05:19

Hallo,
I have rows in column with numeric real numberic values
for with instance
1.23
1.80
2.54

A SELECT query return
1.23
1.8 !!!
2.54
These are a prices and I would like output to be
1.23
1.80 !!!
2.54
ROUND doesn't help and FORMAT not working.
Database in on ACCESS.

bitsmed
Aged Yak Warrior

545 Posts

Posted - 2013-10-15 : 14:07:37

format(your_column,"0.00")

vesben
Starting Member

7 Posts

Posted - 2013-10-15 : 15:50:46

quote:
Originally posted by bitsmed

format(your_column,"0.00")

Thanks,
Working exelent, but in ACCESS instead of
"0.00" SQL accepted '0.00'
vesben

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources