Page 2 of 2
Re: Character datatype
Posted: Wed Jun 13, 2007 1:24 pm
by thamark
I_Server_Whale wrote:thamark,
I have my input and output columns defined as Varchar(100). So that's not what is causing it. I even tried
But it still returns:
Whale.
Then you can verify to see, if you have some un-printable character at end of the string.
Posted: Wed Jun 13, 2007 1:30 pm
by DSguru2B
As a test, try giving a hard-coded value to the Trim() function.
Re: Character datatype
Posted: Wed Jun 13, 2007 3:05 pm
by I_Server_Whale
thamark wrote:
Then you can verify to see, if you have some un-printable character at end of the string.
You are right. Gosh! I feel embarrassed. I should have checked. There is in fact an unprintable character at the end of the string. I removed it and it works fine.
Ray,
Don't bother digging further.
DSguru2B,
Tried hard-coded. It worked.
Sorry for the false alarm, Folks.
Have a good one,
Whale.
Posted: Wed Jun 13, 2007 4:27 pm
by ray.wurlod
<unprintable response>
</unprintable response>
![Wink :wink:](./images/smilies/icon_wink.gif)
Posted: Wed Jun 13, 2007 4:47 pm
by I_Server_Whale
Posted: Wed Jun 13, 2007 11:25 pm
by balajisr
DSguru2B wrote:Unfortunately that does not work. Thats really odd. But the following works to remove tabs.
Code: Select all
Trim(DSLink17.Num1,' ','L')
Trim(DSLink17.Num1,' ','T')
Thanks for the confirmation. I thought i was the only one having this problem.