petak, 2. listopada 2009.

Show 0 instead of NULL

SELECT

CASE WHEN TextField IS NULL THEN '0' END AS txt,
CASE WHEN numberField IS NULL THEN '0' END AS br

FROM dbo.TestTablica