How to replace null with string when column is of datatype int

Question

I have a table with 3 columns and sample data like this:

enter image description here

All columns are of datatype int.

I have this query :

select 
    foodid, dayid 
from 
    Schedule

I want replace dayid with a string if dayid=null .

For this I tried this query :

select 
    foodid,
    Dayid + ISNULL(dayid,'not day') 
from Schedule

but I am getting this ERROR :

Conversion failed when converting the varchar value 'not day' to data type int.

How can do this ?

I want replace dayid with a string id dayid=null it will be null so what different you want? — SMA
– SMA, Commented Mar 1, 2015 at 16:04
Try select foodid,ISNULL(dayid,'not day') from Schedule In your query you are trying to add (dayid + ...). — Matze
– Matze, Commented Mar 1, 2015 at 16:08
@PM77-1 Scheduleid is primary key , and other fileds are foreign key. — Psar Tak
– Psar Tak, Commented Mar 1, 2015 at 16:09

osman Rahimi · Accepted Answer · 2015-03-01 16:09:06Z

4

please try with this:

select foodid, ISNULL(str(dayid),'not day') from Schedule

answered Mar 1, 2015 at 16:09

osman Rahimi

1,5171 gold badge11 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1