RTrim... ?

Question

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

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

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

You do or do not want to trim spaces?

ltrim() - trims left

rtrim() - trims right.

Steve Jones

Bidec SSCommitted Points: 1666 More actions · Answer 2

Its not that I do or do not want to use those functions, the thing is they dont work.

I tried converting it to varchar,char, then ltrim/rtrim but somehow it does not work.

Please let me know if you have any other options.

Thanks,

Chandra

Andy Jones, DBA Hall of Fame Points: 3641 More actions · Answer 3

I just ran

SELECT command,len(command) FROM msdb.dbo.sysjobsteps

and didn't see and spaces at the end of command, are you talking about the grid output in query analyser?

Regards,

Andy Jones

.

Bidec SSCommitted Points: 1666 More actions · Answer 4

I am talking about 'Result in Text' in QA,

(As I want to store the output in a txt file).