i want to move leading zeros from a column. its a unicode column.
i have tried the following
They work but remove all zeros. I just want to remove any zeros at the start of the string and thats it. if any.
also tried this
they just fail
so here is what im looking for in output
001306AB5 - 1306AB5
00135TAB0 - 135TAB0
what im getting from the logic that works
001306AB5 - 136AB5
00135TAB0 - 135TAB
any help would be great