Appending case to varchar in select

make sure you have an "else";otherwise you will append in some cases a null which will blot out the select