SELECT ADCD,
ADNM,
case when CAST(PCOUNT AS VARCHAR) ='0' then '/' when CAST(PCOUNT AS VARCHAR) IS NULL then '/' else CAST(PCOUNT AS VARCHAR) end as PCOUNT,
case when CAST(HTCOUNT AS VARCHAR) ='0' then '/' when CAST(HTCOUNT AS VARCHAR) IS NULL then '/' else CAST(HTCOUNT AS VARCHAR) end as HTCOUNT,
case when CAST(LDAREA AS VARCHAR) ='0.00' then '/' when CAST(LDAREA AS VARCHAR) IS NULL then '/' else CAST(LDAREA AS VARCHAR) end as LDAREA,
case when CAST(PLAREA AS VARCHAR) ='0.00' then '/' when CAST(PLAREA AS VARCHAR) IS NULL then '/' else CAST(PLAREA AS VARCHAR) end as PLAREA,
case when CAST(HOUSE AS VARCHAR) ='0' then '/' when CAST(HOUSE AS VARCHAR) IS NULL then '/' else CAST(HOUSE AS VARCHAR) end as HOUSE,
PREVTP,
LGTD,
LTTD
FROM IA_ADC_ADINFO WHERE ADCD LIKE '%%' AND ADNM LIKE '%%' AND PREVTP LIKE '%%'