Thank you all very much.

That works for me and we will surely be using and testing the code in our application.

Did I mention This is the best support forum:-D:-D

Trailing zeroes are fine and the output will be in VARCHAR columns

I must state my request clearly:(

The columns Modifier and result are not in the table,I need to create those as output.

The table only has ColumnA.

Basically given any input with upto...