Removing white space

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 1

SELECT REPLACE( SomeColumn, SPACE(1), '' ) FROM SomeTable

--Ramesh

Johan Bijnens SSC Guru Points: 135590 More actions · Answer 2

or if you only want to trim leading or trailing spaces you can use :

SELECT RTRIM(LTRIM(mycol))

FROM myobject

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this