var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ltrim and rtirm is not working
Hi i have a select statement as
select empnum, len(empnum), ltrim(rtrim(empnum)), len(ltrim(rtrim(empnum))) from employee
When i execute this stament i get the following
1234 6 1234 6
4321 8 4321 8
1111 6 1111 6
2222 6 2222 6
How does this happens. Why ltrim and rtrim is not working here.
what are you using to display these results, query analyser? enterprise manager? something else?
the length of 1234 is clearly not 6
What does this yield:
select 'X' + ltrim(rtrim(empnum)) + 'X' from employee
ltrim(rtrim) not working
Ive got it, the input statement is from vb.net source, and the programmers have stored vbcrlf after each string. char(13) stored at the end and that is the reason y ltrim and rtrim is not working.
I removed the char(13) at the end and now it is working.
Thanks for your time