TSQL help neede for converting numbers

[yo-vb]

Hi vb experts!

I am using vb6 + sql2000. How can I convert a number (integer or decimal) to CHAR format, where the length is 12 and I have to fill the empty characters with 0s. Ex: 128 - 000000128,00 or 1223.2 - 000001223,20. I can write an algorithm to do that, but I'm pretty sure that there are easier ways. Thx for your help!

[RvA]

Hello yo-vb

Ok I would do that with a format statement.

Private Function FormatNum(ByVal iNum As Integer) As String
  Dim sRtn As String
 
  sRtn = Format(iNum, "000000000000")
  FormatNum = sRtn
 
End Function

I think that would be the easiest way to handle that one.

Hope that helps a little.

[BruceG]

He's looking for the T-SQL way to do it. Try this:
SELECT RIGHT('000000000000' + CONVERT(VARCHAR(12), YourNumField), 12) AS FormattedField FROM YourTable etc. etc.