There is an option "Row Visibility" in SSRS, through which you can control the table row visibility. You can use the same expression to control that row visibility which causing...

Hi Kapil, I not sure where you are going wrong, but it should work.

Try -

SELECT*

FROMTableA

WHEREPATINDEX('%[ ]cd[ ]%', [Values]) > 0

OR PATINDEX('%[ ]cd', [Values]) > 0

OR PATINDEX('cd[ ]%', [Values]) > 0