© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•2y ago•
3 replies
mrdudebro1

how to use 'like' in SSRS

HI ALL. i have a query where i'm trying to use 'like' with a parameter and it doens't seem to be working.

select po_hdr.po_no, po_hdr.order_date, po_hdr.created_by, expdite_date, next_action, vendor_name, supplier_so, contact_id,
contacts.email_address, contacts.direct_phone, contacts.home_phone, contacts.phone_ext, ackn_date
from po_hdr_ud
join po_hdr on po_hdr.po_no = po_hdr_ud.po_no
join vendor on vendor.vendor_id = po_hdr.vendor_id
left join contacts on po_hdr.contact_id = contacts.id
WHERE (po_hdr.po_no = @RG_PO_NO or @RG_PO_NO is null) AND (po_hdr_ud.supplier_so LIKE @Supplier_SO or @Supplier_SO = '') AND (vendor_name like '*'+@
Supplier_Name+'*' or @Supplier_Name = '') and (po_hdr.created_by LIKE @RG_Buyer or @RG_Buyer = '')
select po_hdr.po_no, po_hdr.order_date, po_hdr.created_by, expdite_date, next_action, vendor_name, supplier_so, contact_id,
contacts.email_address, contacts.direct_phone, contacts.home_phone, contacts.phone_ext, ackn_date
from po_hdr_ud
join po_hdr on po_hdr.po_no = po_hdr_ud.po_no
join vendor on vendor.vendor_id = po_hdr.vendor_id
left join contacts on po_hdr.contact_id = contacts.id
WHERE (po_hdr.po_no = @RG_PO_NO or @RG_PO_NO is null) AND (po_hdr_ud.supplier_so LIKE @Supplier_SO or @Supplier_SO = '') AND (vendor_name like '*'+@
Supplier_Name+'*' or @Supplier_Name = '') and (po_hdr.created_by LIKE @RG_Buyer or @RG_Buyer = '')


when i type in a value into the supplier_name parameter that SHOULD return something .it returns nothing
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

❔ SSRS PDFs to Sharpoint
C#CC# / help
4y ago
✅ SSRS | How To Upload Multiple RDL File to Report Server ?
C#CC# / help
2y ago
how to use wirteLine in monogame
C#CC# / help
17mo ago
SSRS add repeating title ABOVE column groups
C#CC# / help
2y ago