Hi,
I have a field (A) coming in as varchar(22)
the data of that field is like this EMP.SALE..1978
the target table has this field as integer (10)
I need to strip off 'EMP.SALE' and convert the rest of the
number as integer.
I need to populate only 1978
What function works for this kind of conversion?
Thanks.
datatype conversion
Moderators: chulett, rschirm, roy
Re: datatype conversion
I resolved it .laxmi_etl wrote:Hi,
I have a field (A) coming in as varchar(22)
the data of that field is like this EMP.SALE..1978
the target table has this field as integer (10)
I need to strip off 'EMP.SALE' and convert the rest of the
number as integer.
I need to populate only 1978
What function works for this kind of conversion?
Thanks.
When I use the fallowing function it is working good.
Substrings(lnkdummy.A,11,22)