how to remove all spaces in a string
example: jhon is good
i need out put as jhonisgood
how to remove all spaces in a string
Moderators: chulett, rschirm, roy
Code: Select all
CONVERT(' ','',In.ColumnName)
Code: Select all
TRIM(In.ColumnName,' ','A')
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: