Hi can someone help with this SQL query please? I am trying to retrieve a list of matching addresses based on what the user enters:
ExecuteSQL ( "
UPPER(surname) LIKE ? and
UPPER(firstname) LIKE ? and
UPPER(postcode) LIKE ?
; "" ; "";
The above code kind of works but it does not account for fields that are NULL
The problem being if I enter in "Smith" for the surname I ONLY get results if there is date in the firstname field (which there often isnt)
I have attached a demo file