Home Forums SQL Server 2005 Development How to add "dot" after every three digits in a number in sql 2005 RE: How to add "dot" after every three digits in a number in sql 2005

  • Also your soultion is not ideal because it needs a substring function for each three digits, so if you want to convert a large number like " 46905730295547" to the required format , you will need to write a a new conversion with 5 sub string functions, and so on.

    So, I think we need another solution to get every three digits dotted in a number data.