V_SIMPLEDATALIST_PHONECURRENT

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:08:27 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_PHONECURRENT AS



                select 
                        PHONE.ID as VALUE,
                        (coalesce(PHONETYPECODE.DESCRIPTION + '-', '') + (case when PHONE.ISPRIMARY=1 then 'primary-' else '' end) +
                        case when PHONE.NUMBER = N'' then '<No phone number>' else coalesce(left(PHONE.NUMBER, charindex(nchar(10), PHONE.NUMBER + nchar(10)) -1), '<No phone number>') end 
                        ) as LABEL    
                    from dbo.PHONE
                    left outer join dbo.PHONETYPECODE on PHONETYPECODE.ID = PHONE.PHONETYPECODEID