select IsNull(ColNm,'-') from TblNm
select case when ColNm is null then '-' else ColNm end as ColNm from TblNm
select isnull(name,'') from sales
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)