Hi All

I am performing a SELECT query and I need to make sure that any NULLs within the records I am querying are converted to 0 just for the life of the query.

Can anyone guide me in what the syntax would be to achieve this?

Ta

Rich

__________________
Rit
www.designandonline.co.uk
INSPIRE | CREATE | DELIVER

select coalesce(field,0) or
select isnull(field,0)



------------------------------------------ http://sqlservercode.blogspot.com/

Wow that was a quick response... must have been an easy Q.

Many thanks!