0 OR LEN(ISNULL(Prsn.[CITY],'')) > 0 OR (Prsn.[Country] IS NOT NULL) OR LEN(ISNULL(Prsn.[PostalCode],'')) > 0 THEN ISNULL(Prsn.[Street],'') ELSE Org.[Street] END AS [Street] ,CASE WHEN LEN(ISNULL(Prsn.[Street],'')) > 0 OR LEN(ISNULL(Prsn.[CITY],'')) > 0 OR (Prsn.[Country] IS NOT NULL) OR LEN(ISNULL(Prsn.[PostalCode],'')) > 0 THEN ISNULL(Prsn.[City],'') ELSE Org.[City] END AS [City] ,CASE WHEN LEN(ISNULL(Prsn.[Street],'')) > 0 OR LEN(ISNULL(Prsn.[CITY],'')) > 0 OR (Prsn.[Country] IS NOT NULL) OR LEN(ISNULL(Prsn.[PostalCode],'')) > 0 THEN ISNULL(Prsn.[Region],'') ELSE Org.[Region] END AS [Region] ,CASE WHEN LEN(ISNULL(Prsn.[Street],'')) > 0 OR LEN(ISNULL(Prsn.[CITY],'')) > 0 OR (Prsn.[Country] IS NOT NULL) OR LEN(ISNULL(Prsn.[PostalCode],'')) > 0 THEN ISNULL(PCntry.[Name],'') ELSE OCntry.[Name] END AS [Country] ,CASE WHEN LEN(ISNULL(Prsn.[Street],'')) > 0 OR LEN(ISNULL(Prsn.[CITY],'')) > 0 OR (Prsn.[Country] IS NOT NULL) OR LEN(ISNULL(Prsn.[PostalCode],'')) > 0 THEN ISNULL(Prsn.[PostalCode],'') ELSE Org.[PostalCode] END AS [PostalCode] FROM [Person_View] Prsn LEFT JOIN [Organization_View] Org ON Org.Id = Prsn.Organization LEFT JOIN Country_View PCntry ON PCntry.Id = Prsn.Country LEFT JOIN Country_View OCntry ON OCntry.Id = Org.Country WHERE (Prsn.[IsActive] = 'true' AND ISNULL(Org.[IsActive],'true') = 'true') OR @ShowAll = 'true' ORDER BY [Name], [Organization], [Country] ]]> DataGrid