special characters such as '¬', crtl B, crtl A etc from sybase to TD

Data Modeling

special characters such as '¬', crtl B, crtl A etc from sybase to TD

Hello,

recently i been assinged a major Migration project in my recent company. so there are bunch of existing & working sybase code/jobs i am converting to TD one by one. I came across with one challenging code where we are concnating 2 strings and in btween them we are adding '¬'/crtl B. for same results, we are using XXXX+char(2)+YYYY in sybase. 

when i tried same approach, it didnt work. i tried 1234||char(2)||5678, 1234||char(002)||5678 no results. I know i can replace char(2) (which is '¬'/crtl B in sybase) with '¬' and make final run. but thar'd be incorrect. 

Can some one please help me on the same? its urgent. 

Thank you IN ADVANCE

1 REPLY
Junior Contributor

Re: special characters such as '¬', crtl B, crtl A etc from sybase to TD

What's your TD release?

In TD14 there's a CHR(2) function, or you can use a hex-literal '02'xc