Equivalent function for DIGITS in Parallel

kirannumb · Post by **kirannumb** » Fri Jul 16, 2010 10:37 am

Hi All,

I am trying to find equivalent function for DIGITS function in Parallel jobs. I have the following in the Server job:

link.Column_NUMBER : DIGITS(link.REFERENCE_NUMBER)

Can anyone please post the equivalent function.

Thanks

anbu · Post by **anbu** » Fri Jul 16, 2010 10:49 am

Code: Select all

Convert(Convert('0123456789','',REFERENCE_NUMBER),'',REFERENCE_NUMBER)

kirannumb · Post by **kirannumb** » Fri Jul 16, 2010 12:05 pm

anbu wrote:

Code: Select all

Convert(Convert('0123456789','',REFERENCE_NUMBER),'',REFERENCE_NUMBER)

Thanks for the reply. In the above code '0123456789' represents DIGITS and your are suggesting to replace DIGITS(DSLink8.REFERENCE_NUMBER) wit the above code ?

anbu · Post by **anbu** » Fri Jul 16, 2010 12:14 pm

chulett · Post by **chulett** » Fri Jul 16, 2010 9:38 pm

Plot out what those in-lined Converts do, first the inner one and then the outer. Quite clever, actually, made me smile the first time I saw it here.