Q:

How to insert a string in stored procedure

When I try to insert a string in stored procedure, it is showing error message...
Select empcode, isnull(name, + ''0'' +) from employee

The above query is showing error, when I try with single quotation, then the result is same
How to insert a string in a stored procedure.
Need query help

A:

Try either
Select empcode, isnull(name, ''0'') from employee

or
Select empcode, isnull(name, '0') from employee

Choose one which suits without errors.

