Coalesce example

Question

hi frnds,
can any 1 tell me what is coalesce and how we can use it in our Sql Query.
pls give an example.


Thanks & Regards,
Aamir