RTrim not working in sql server 2005-2008
Hi Looked over the net but could find a solution
Could anybody tell me why the following would not work?Am I missing the
obvious!!
SELECT RTRIM('99999 ')
You cannot see very well from above after 99999 I have many empty spaces.
My field contains numbers and I could do
SELECT LEFT(Myfield,8) and this would work but I dont know the length of
the field.
any suggestions
Thanks
No comments:
Post a Comment