USP_DATALIST_CONSTITUENTADDRESSTOKENS

CREATE procedure dbo.USP_DATALIST_CONSTITUENTADDRESSTOKENS(
  @VALUETYPE tinyint,
  @COUNTRYID uniqueidentifier,
  @ORIGINALVALUE nvarchar(255) = null,
  @REPLACEMENTVALUE nvarchar(255) = null
)
as
    set nocount on;

    select ADDRESSTOKEN.ID as ID,
           TOKENTYPE as VALUETYPE,
       COUNTRY.DESCRIPTION as COUNTRY,
       TOKEN as ORIGINALVALUE,
       TRANSLATION as REPLACEMENTVALUE
    from dbo.ADDRESSTOKEN
  left join dbo.COUNTRY on COUNTRY.ID = ADDRESSTOKEN.COUNTRYID
    where TOKENTYPECODE = @VALUETYPE and 
  COUNTRYID = @COUNTRYID and 
  (@ORIGINALVALUE is null or lower(TOKEN) like '%' + lower(@ORIGINALVALUE) + '%') and
  (@REPLACEMENTVALUE is null or lower(TRANSLATION) like '%' + lower(@REPLACEMENTVALUE) + '%')
  order by TOKEN,TRANSLATION asc