I have a report that selects certain records based on what the user enters
for the parameter but I'm trying to allow the user to enter a wildcard and
show the relevant records. I used like and had the user add an * or even a %
but it still returns nothing. Records are returned only when the user enters
the full value with no wildcards. Help.

SELECT DISTINCT
PDFBM.ASSEMBLY_ID, PDFBM.COMPONENT_ID,
PDFBM.REQUIRED_QTY, ICFPM.PART_DESC, ICFPM.DWG_REV, ICFPM.PENDING_ECN,
dbo.ICFSS.STORES_CODE, dbo.ICFSS.STOCK_LOCATION
FROM dbo.ICFPM ICFPM INNER JOIN
dbo.PDFBM PDFBM ON ICFPM.PART_ID = PDFBM.ASSEMBLY_ID
INNER JOIN
dbo.ICFSS ON ICFPM.PART_ID = dbo.ICFSS.PART_ID
WHERE (PDFBM.COMPONENT_ID LIKE @componentid) AND (PDFBM.ASSEMBLY_ID LIKE
'350%')
ORDER BY PDFBM.ASSEMBLY_ID, PDFBM.COMPONENT_ID

A

This is an old thread in this forum. I think it answers your question.

http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/e8778479df35d4fe/482a1cd2b2c1dad1?q=%3Dstring.Format(%22SELECT++PartID&rnum=1#482a1cd2b2c1dad1

I tried to add the + '%' as listed on all the scenarios but I still didn't
get any results when the user entered a partial value for the field.

[quoted text, click to view]