Hi,
I have got some aplhanumeric values like 9125a, 9625aa. Now I need to convert the 'a's into 0. So, it should be like 91250, 962500. Plz give some hint how to do it in transformer.
Regards,
Arnie.
Alphanumeric/Transformer
Moderators: chulett, rschirm, roy
Read the column as varchar then
Code: Select all
If IsNull(columnname) then @NULL Else If Num(columnname)=0 Then Convert('a','0',columnname) Else columnname