Hi All,
Here i am getting values (Ex: -00005 Or 00009) from source as Decimal (5). If it is -00005 then out put should be 0000A and if it is 00009 then 0000X.
Can any body explain me how to do this...Thanks
Thanks
Chilli
Convert Decimal to Varchar
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Convert Decimal to Varchar
Why?chilli wrote:If it is -00005 then out put should be 0000A
Why?chilli also wrote:and if it is 00009 then 0000X.
What other possibilities exist?
Please fully document the transformation rule.
Note also that your target data type can not be Decimal.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.