WHEN CHARINDEX('-cl', IntCustName) > 0 THEN TRIM(LEFT(IntCustName, CHARINDEX('-cl', IntCustName) - 1))
WHEN CHARINDEX('*CAS', IntCustName) > 0 THEN TRIM(LEFT(IntCustName, CHARINDEX('*CAS',CHARINDEX</em
(''['',criteriavalue,8)+1,charindex('']'',criteriavalue,14)-charindex(''['',criteriavalue,8)-1)when ''Agent'' then substring(criteriavalue,charindex(''['',criteriavalue,8)+1
)+1 ELSE CHARINDEX('&',@strprog,CHARINDEX('&OR=',@strprog)+4 ) END -CHARINDEX('&OR=',@strprog)-4 )
SET @MR= SUBSTRING(@strprog,CHARINDEX('&MR=',@strprog)+4,CASE WHEN CHARINDEX('&