detect trailing spaces

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

SELECT MyColumn FROM MyTable

WHERE RIGHT(MyColumn, 1) = ' '

John

want_to_know SSC Veteran Points: 256 More actions · Answer 2

SSC Veteran

Points: 256

April 28, 2008 at 10:05 am

Thanks a lot

God Bless you

Jeremy-475548 Hall of Fame Points: 3065 More actions · Answer 3

Hmmm...or more circuitously:

Select * From table where len(myColumn) + 1 <> len(myColumn + '.')

I'm sure there's a flaw in my logic here, but the idea is to exploit the behavior of the len function, which does not count trailing spaces.

(I discovered this the hard way....)

GSquared SSC Guru Points: 260824 More actions · Answer 4

That works, Jeremy. Not sure why anyone would do it, but it does work. 🙂

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon