80459ÿÿÿÿÿ

[Sainath.Srinivasan]

If you want to correct, try a convert or trim.

If you want to identify the char, try preparing various ascii chars and matching them with the char you obtain.

[ranga1970]

I was of the opinion trim takes care of leading and trailing space??
any how I tried that before doing my first post it self and it dint work?

If you want to identify the char, try preparing various ascii chars and matching them with the char you obtain

could you be elobarative I did not Understand
Look like I needd

[ds_developer]

Your assumptions are not correct. The right way to substring is:

Link.sourcefield[1,5]

Syntax is [start,length]

John

[kduke]

It is probably a char(254) or char(253). You can check it with seq().