I figured it out. In my sql statement I specified the following:

charindex(rtrim(SOP30200.STATE),@testing) >0

and set my value associated to label A to: (state "space" state )

IL KS MI

The report...

I will check out the link and hopefully test it tonight, Thanks for your reply..what is the easiest method?

thanks for your help. I will test this today

The only records I want to be pulled if (@test) = 1 would also have to have a POP30300.TRXSORCE value like 'recvg%'

If (@test) = '2' then POP30300.TRXSORCE must also be...

any help on this would be greatly appreciated

I have attached the full query. I am now getting an error "must declare the scalar variable for @start" I have never worked with scalar variables.

SELECT POP30310.PONUMBER, POP30310.ITEMNMBR, POP30310.ITEMDESC, POP30300.GLPOSTDT,...

not sure. the value could be just 1 or 1,2 or 1,3 or 2,4. could be any combination. 1,2,3,4

I still receive the following error when selecting multiple values in the @type multi-select parameter. Invalid syntax near ','.

I only receive it when select more than one value in...

One thing that I forgot to mention is that the @type field is a multi-selection field, with 4 possible selections. 2 of the available values to select rely on 'abc%'...