Ne bogi gorshki obzhigajut :)

Thanks, I got another solution from Borislav which is a bit shorter

CASE WHEN ISNULL(Status,'')='' THEN 'M' ...

I'm not sure when we switch to 2008 if ever.

>You are welcome.
>Но я не волшебник, я только учусь :)
>Just started working on the SQL Server 2005 and there is new 2008 already released.
>