New line break - ( I am new to the world of sql server) 
Author Message
 New line break - ( I am new to the world of sql server)
Hi,
  I have created a trigger which sends emails to users, and am trying
beautify the email output a little. Is there a way in which I can for
example specify new line breaks. If so is there a command which can handles
this?

thanks in advance for your help



Mon, 12 Aug 2002 03:00:00 GMT
 New line break - ( I am new to the world of sql server)

Andy.

Quote:
>  I have created a trigger which sends emails to users, and am trying
>beautify the email output a little. Is there a way in which I can for
>example specify new line breaks. If so is there a command which can handles
>this?

I know nothing about using it for mail, but to put line breaks in a
SQL result I use:

  SELECT 'First line' + char(13) + char(10) + 'Second line'

Roy



Mon, 12 Aug 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Help I am new to SQL server

2. Sybase Adaptive Server Enterprise Achieves New World Record TPC-C ResultsDate: February 23, 1998

3. US-New York/New Jersey - SQL SERVER DBA'a and Developers

4. New Year/New Career: London Based - Energy Trading - DBA's (ORACLE/Sybase/SQL Server)

5. New Year/New Career: London Based - Energy Trading Software - DBA's (ORACLE/Sybase/SQL Server)

6. New Year/New Career: London Based - Energy Trading - DBA's (ORACLE/Sybase/SQL Server)

7. New Year/New Career: London Based - Energy Trading Software - DBA's (ORACLE/Sybase/SQL Server)

8. New Year/New Career: London Based - Energy Trading - DBA's (ORACLE/Sybase/SQL Server)

9. New Year/New Career: London Based - Energy Trading Software - DBA's (ORACLE/Sybase/SQL Server)

10. New to SQL, easy question I am sure

11. Please help, I am new to Jet Engine and SQL

12. kyduke(kyduke@yahoo.com)'s New Logic - New sorting, New paging method


 
Powered by phpBB® Forum Software