removed white space in leading or behind the character

Last Post 20 Apr 2005 03:27 AM by Ado_SQL. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
samkry
New Member
New Member

--
19 Apr 2005 11:57 PM
Hi..
How could i removed the white empty space in behind the character or leading character..
I hear we can use Trim but how to apply it on select statement???
Ado_SQL
New Member
New Member

--
20 Apr 2005 03:27 AM
If I understand you correctly, something like:

select ltrim(<col> ) from <table> as t

Should do it, or

select ltrim(rtrim(<col> )) from <table>

to remove both leading and trailing spaces.

HTH
You are not authorized to post a reply.

Acceptable Use Policy