> Hi,
>
> I am trying to set up a job to check on certain updates
> done on my database, if no updates done, then it will send
> out email to me use master..xp_sendmail.
>
> when I try to assing @message, I want to assign a string
> to it and a varchar variable after the string, which
> contains yesterday's date: @message = 'There was no data
> replicated in db1 table1 yesterday.' + @Yesterday + '.',
> it complains at the '+'.
>
> But if I do: PRINT 'There was no data replicated in db1
> table1 yesterday, ' + @Yesterday + '.', it print out the
> message successfully.
>
> How should I do it?
>
> Many thanks.
>
> JJ
>