case when (pnl.seccodedesc in('NA Debt - East','NA Debt - West','NA Debt - Central','NA Debt - Strategic Cap.') or(pnl.seccodedesc like 'SI -%')) then '1US' when pnl.seccodedesc='NA Debt - Canada' then '3Canada' when pnl.seccodedesc='NAL - Mexico' then '4Mexico'end as Region
SELECT LastName,FirstName,Address FROM Persons WHERE Address IS NULL
Where ISNULL(pnl.seccodedesc,'') <> ''
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)