USP_SIMPLEDATALIST_PHONECURRENT

CREATE procedure dbo.USP_SIMPLEDATALIST_PHONECURRENT
(
@CONSTITUENTID uniqueidentifier = null
) 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
                    where PHONE.CONSTITUENTID = @CONSTITUENTID 
                    and PHONE.ENDDATE is null
                    order by PHONE.ISPRIMARY desc,PHONETYPECODE.DESCRIPTION,PHONE.NUMBER