SELECT     REPLACE(SUBSTRING(Note, 1, DATALENGTH(Note)), CHAR(13), '<BR>') AS Expr1
FROM         OLD_NOTES

--If all arguments are NULL, COALESCE returns NULL.
COALESCE(expression1,...n) 
--is equivalent to this CASE function:
CASE
WHEN (expression1 IS NOT NULL) THEN expression1
--...
WHEN (expressionN IS NOT NULL) THEN expressionN
ELSE NULL

public static string AppPath()
{return AppDomain.CurrentDomain.BaseDirectory;}

	declare @email nvarchar(255)
	declare CustList cursor for
		SELECT email from STE_EMAILS
	OPEN CustList
	FETCH NEXT FROM CustList 
	INTO @email
	WHILE @@FETCH_STATUS = 0
	BEGIN
	  if (SELECT count(custid) from customer where (current_customer=1) and (notes1 is not null) and (notes1 like '%' + @email + '%')) > 0
		SELECT custid from customer where (current_customer=1) and (notes1 is not null) and (notes1 like '%' + @email + '%')
		print '%' + @email + '%'
	  FETCH NEXT FROM CustList INTO @email
	END
	CLOSE CustList
	DEALLOCATE CustList

    static class QuickMail
    {
        public static void SendMail(string from, string to, string subject, string messageText, bool isHtml)
        {
			SmtpClient mymail = new SmtpClient(ConfigurationManager.AppSettings["localsmtp"]);
			MailMessage message = new MailMessage(from, to, subject, messageText);
			message.IsBodyHtml = isHtml;
			mymail.Send(message);
        }
    }