Use the crlf function of what ever language you are using. For example if you are using VB use the VBCRLF to put a line feed in there. If you are using T/SQL then simply put a line feed within the String.
<pre>DECLARE @s as VARCHAR(100)
SET @s = ‘This is a string.
This is a second string’
When you view the value in the SQL grid it will always show as a single line. It you view it in the text mode the line feeds will show correctly.