Wildcard in dataset filter query
Posted on 2013-01-08
I'm adding a query with a filter to a dataset with the designer.
My query is:-
SELECT Counter, SiteRef, ccount, SiteName, AddressLine1, AddressLine2, AddressLine3, Town, Postcode
WHERE (Postcode = @POSTCODETOFIND )
This works OK but I'm struggling to get the LIKE and wildcard option to work.
Please could you suggest the correct syntax.