Hi, I have a flat file with a field like this:
'AAAABBBBCC0000123456700DDDFFF'
the number 0000123456700 is a decimal(13, 5) but in this flat file there's no decimal separator.
I try with a cast but it doesn't work.
Any idea's?
Many thanks.
'AAAABBBBCC0000123456700DDDFFF'
the number 0000123456700 is a decimal(13, 5) but in this flat file there's no decimal separator.
I try with a cast but it doesn't work.
Any idea's?
Many thanks.
Comment