SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0

Transact-SQL
1

I have the following code:

SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622') GROUP BY Component

How do I get the SELECT to return zero instead of NULL when there is no match?

2

Got the answer on another Forum…

SELECT COUNT(DISTINCT Component) AS 'Found' FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')