Hi,

I am working on a migration from DB2 to SQL, i found one of my UDFs using the DIGITS() function. Can anybody suggest me what is the alternative in SQL.

Thank you...

Try CONVERT() or CAST()

Thanks...any examples? and what would be the target data type when we do the conversion?

DIGITS returns a character string representation of a number with leading zeros. The length of the character string depends on the data type of the number.

Small Integer returns a CHAR 5
Large Integer returns a CHAR 10
Big Integer returns a CHAR 19
Decimal returns a CHAR x where X is the Precision of the Decimal.

There isn't an exact equivalent in SQL. The closest single function is STR whose format is STR(value, length).

If you have a Smallint value of 29 you would use STR(29,5).

This will return a right justified number WITHOUT leading zeros.
If you can not work without leading zeros, you will need to do more work to add them.

So, you are planning to complete migration without ever opening the manual, aren't you? Good luck with that.