Find task with wildcards?

Question

‌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

adrian.marsden_DevonCC · Answer

Not yet - it would take a fair bit of re-coding - not that urgent at the moment - thanks anyway.

RobertScheitlin__GISP · Answer

Adrian,

Good to know. So have you tried the queryTask using that where clause?

adrian.marsden_DevonCC · Answer

Ah

sql server - What is the meaning of the prefix N in T-SQL statements? - Stack Overflow‌

You may have seen Transact-SQL code that passes strings around using an N prefix. This denotes that the subsequent string is in Unicode (the N actually stands for National language character set). Which means that you are passing an NCHAR, NVARCHAR or NTEXT value, as opposed to CHAR, VARCHAR or TEXT.