Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jason Selburg Data Driven Subscriptions Updated RE: Data Driven Subscriptions Updated

  • November 29, 2011 at 11:18 am

    #1414263

    Try this:

    DECLARE @crlf char(2) = CHAR(13) + CHAR(10)

    SELECT @emailBODY = 'first' + @crlf + 'second' + @crlf + 'third'

    Note: for paragraphs, just double the @crlf, i.e.

    SELECT @emailBODY = 'first' + @crlf + @crlf + 'second' + @crlf + @crlf + 'third'

    [font="Tahoma"]Zycon - The Search Engine for Manufacturers[/url]. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.[/font]