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.
>
If it's not broken, fix it until it is.
My Blog