USP_SEARCHLIST_PDACCOUNTSEGMENTVALUE

CREATE procedure dbo.USP_SEARCHLIST_PDACCOUNTSEGMENTVALUE
(
    @PDACCOUNTSTRUCTUREID uniqueidentifier,
    @SHORTDESCRIPTION nvarchar(100) = null,
    @DESCRIPTION nvarchar(100) = null,
    @MAXROWS smallint = 500
)
as
  --sanitize the search values

    set @SHORTDESCRIPTION = dbo.UFN_TEXTSEARCH_SANITIZE(@SHORTDESCRIPTION,'/',DEFAULT,0,DEFAULT)+'%' ;
  set @DESCRIPTION = dbo.UFN_TEXTSEARCH_SANITIZE(@DESCRIPTION,'/',DEFAULT,DEFAULT,DEFAULT) ;

    select top(@MAXROWS)
        ID as ID,
        SHORTDESCRIPTION,
    DESCRIPTION

    from 
        dbo.PDACCOUNTSEGMENTVALUE
    where
        PDACCOUNTSTRUCTUREID = @PDACCOUNTSTRUCTUREID
        and SHORTDESCRIPTION like @SHORTDESCRIPTION escape '/'
    and DESCRIPTION like @DESCRIPTION escape '/'
    order by 
        SHORTDESCRIPTION, DESCRIPTION