Returning NULL's as 0

[IanStrange]

Hi
Kind of a noob question. I have created a few views to speed my crystals up but I want the NULL's in some of the columns to show as zero's. I think it is quite a simple statement but I am not sure of the syntax.
Thanks for any help.

No man is an island but 6 tied together make quite a good raft.

 

[RobertT687]

Select Isnull([yourcolumnname],0) as YourColumnHeader

 

[IanStrange]

Marvelous thanks

No man is an island but 6 tied together make quite a good raft.