0 THEN 'Red' WHEN CHARINDEX('!2',Org.[Abbreviation]) <> 0 THEN 'Yellow' WHEN CHARINDEX('!3',Org.[Abbreviation]) <> 0 THEN 'Green' WHEN CHARINDEX('!4',Org.[Abbreviation]) <> 0 THEN 'Blue' WHEN CHARINDEX('!5',Org.[Abbreviation]) <> 0 THEN 'Orange' WHEN CHARINDEX('!6',Org.[Abbreviation]) <> 0 THEN 'Teal' WHEN CHARINDEX('!7',Org.[Abbreviation]) <> 0 THEN 'Violet' WHEN CHARINDEX('!8',Org.[Abbreviation]) <> 0 THEN 'Black' WHEN CHARINDEX('!9',Org.[Abbreviation]) <> 0 THEN 'Black' WHEN CHARINDEX('!0',Org.[Abbreviation]) <> 0 THEN 'Black' ELSE 'Black' END AS StatusBarColor ,HOST_NAME() AS HostName ,@@SERVICENAME AS InstanceName FROM dbo.[PDXpertInfo_View] Info CROSS APPLY [EmailSettings_View] Email CROSS APPLY [PDXpertLic_View] Lic INNER JOIN Organization_View Org ON Org.Name = Lic.Organization ]]> Table2