Null values

From: Loretta (anonymous_at_discussions.microsoft.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 15:24:44 -0700

How can I replace null value of a column in a query
with something like 'TEST'

for eg. if I run the query
select contract_num, prodid from product

if the contract_num is null, it should return 'TEST'
instead of NULL. how can I do so?

Thank you,
-Loretta