DSXchange

Hi,

I need your help in finding the solution. I have a column called E_NO which is Varchar(20) from the source but sometimes it has numbers in it I mean 146700 .Before loading this into target I need to add DR to it . But how can I check the field has numeric data . If numeric then add DR to it else pass it on the same

I appreciate your replies.

Thanks
rajeev

Hi anbu

I need to add DR in front of the numeric data

For example : I have 145000 from the source data as it is numeric it should be loaded into the target as DR145000

I need to check in for the numbers if it is then I need to append DR in front of it else pass it on the same to the target

Thanks anbu

It worked Now the numeric data has been into the target with DR in front of it .

Thanks a lot .I really appreciate it.

rajeev

You can use the 'isvalid' function

Regards
Sreeni

You can also use AlNum function