I'm trying to re-create this T-SQL in a find task
SELECT OBJECTID, UPRN, LADDRESS, PASTEADDRESS, LOGICAL_STATUS, LPIKEY, PROPERTY_TYPE, ORGANISATION, USRN, STREET_NAME, TOWN_NAME, LOCALITY, POSTCODE, POSTTOWN, UPDATED, STREET_REF_TYPE, POSTALLYADDRESSABLE, PROPERTYSTATE, LPISTATUS, XREF, YREF, Shape, SortPAON FROM v_ADDRESSES_FULL_LLPG WHERE (PASTEADDRESS LIKE N'1 %FORE STREET%')
The important bit is the WHERE.
This will return "1 Fore Street" but also " 1 The Fishermans, Fore Street" , "1 - 4 Forestreet" and a host of others.
How do I specify this in a query for a find task?