Look familiar??

Yeah it did.....

:blush:

Thanks for you're reply. I was looking in the wrong directions....

It now works fine. Never thought it would.

Pim Verkley

Garadin,

Thanks for your reply. Underneath is the code that I use in the view that I call from SP_SEND_DBMAIL.

I learned from trial and error that the line:

, ISNULL([Beaufort].[dbo].[dpic300].[uitdnst_dt], '30-12-2099')...

Tom Goltl (11/19/2007)

---

You can also use char(39) as a single quote.

Example.

Select char(39) + name + char(39) from sysobjects

Just build your string using char(39) to surround your strings. I find...

In reply to EvilPostIT:

Great this works!!!

In reply to Kishore.P I can say, this works, only the single quotes to enclose the string are missing.

I added some quotes and now it...