Formatting TO_CHAR - 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

Formatting TO_CHAR

Author

Topic

augustocolom
Starting Member

4 Posts

Posted - 2010-06-16 : 11:49:12

Hello,
Need to get the value of this tuple formatted. with
SELECT TO_CHAR (FATFATU.CCCOMFATU, '000, 000.0000000 "), you only with commas. Needs to be '000-000 / 0000000 ', any suggestions?

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2010-06-16 : 11:54:32

This is how to do it in SQL Server, hopefully you can adapt it to your needs.

SELECT REPLACE(REPLACE(FATFATU.CCCOMFATU,',',' -'),'.',' / ')
Jim

Everyday I learn something that somebody else already knew

augustocolom
Starting Member

4 Posts

Posted - 2010-06-16 : 12:59:53

Exactly
Thanks for your help ...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources