Need a carriage return in a net send statement..

[SteveMe]

Does anyone know how to get a carriage return in a net send message? Please advise. Thanks

Steve

 

[SmileyConspiracy]

I haven’t tried this with net send but can you concatenate char(13) into your message string.
So,

set @message = ‘Hello‘ + char(13) + ‘Steve’

 

[SteveMe]

Unfortunately that doesn't work.

Here's my syntax

EXEC master..xp_cmdshell 'net send userX Line 1 Line 2'

 

[LFCfan]

I dont think you can have a return in a dos command statement