UFN_CONSTITUENTUPDATE_GETSOLICITCODES

CREATE function dbo.UFN_CONSTITUENTUPDATE_GETSOLICITCODES
(
    @CONSTITUENTID uniqueidentifier
)
returns table
  as
  return
    (
    select
        ID,
        SOLICITCODEID,
        case when STARTDATE ='0001-01-01' then null else convert(date,STARTDATE) end STARTDATE,
        case when ENDDATE ='0001-01-01' then null else convert(date,ENDDATE) end ENDDATE,
        COMMENTS,
        SEQUENCE,
        CONSENTPREFERENCECODE,
        SOURCECODEID,
        SOURCEFILEPATH,
        PRIVACYPOLICYFILEPATH,
        SUPPORTINGINFORMATION,
        CONSENTSTATEMENT
    from 
        dbo.CONSTITUENTSOLICITCODE
    where 
        CONSTITUENTID = @CONSTITUENTID
    )