Hello

I have a multi select parameter which brings back data for similar choices even if those are not selected when running the report.

When multiple choices are selected it brings back the followin string:
1030&330&331&111

Im using:
upper(CHARINDEX (service_code, REPLACE ( '{?serv_code}','+','&') )) >0


Example:
If the user selects service code 1030 my data also brings back data for 103 because they are similar. Is there a way for it to only bring back data for 1030 which was the one selected. I cant use = '1030' because the user has the option to select multiple service codes.

Edited by sanchezgmc06 - 20 Sep 2021 at 5:40am

if you bracket the string with a leading & or +, then do an instring on &1030&. That will remove those annoying false positives.

HTH