AnsweredAssumed Answered

Find task with wildcards?

Question asked by amarsden on Aug 12, 2014
Latest reply on Aug 12, 2014 by amarsden

Hi

 

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?


Cheers


ACM

 

 

 

 

This 

Outcomes