SQL ServerでSELECT時にNULLを空文字に置換する

SELECT ISNULL(yourtable.note, '') AS note FROM yourtable;