Thanks for the prompt reply, Lowell.

I am able to do it with 'IsNull', but not with 'Coalesce'.I even tried:

(coalesce(CONVERT([nvarchar](20),[Number],0),'# Not Assigned'))

but does not work.

Thanks

Adish