Many Thanks!

ISNULL helped.

I used:

SET @p1 = ISNULL((SELECT (col1+ col2)

FROM #STOCK

WHERE DAYSTOEXPIRY = '0'),0)

and it worked.

Regards,

SM

I am getting value of @p1 as :

SET @p1 =(SELECT (col1+ col2)

FROM #STOCK

WHERE DAYSTOEXPIRY = '0')

Now, if @p1 is zero, there is nothing displayed in the message which is trying...

In short I want to know:

How to cast integer value zero to string value '0'

Many thanks!

later I am trying to send @message in email @body

and on receiving the email there are no contents

As such, there are no errors appearing on sql.

If @p1 != 0,...