This 4D Query will return records with Last_Name containing both "u" and "ΓΌ":
QUERY([Donors];[Donors]Last_Name="@u@")
This SQL query will only return records with Last_Name containing "u"
Begin SQL
SELECT Last_Name
FROM Donors WHERE Last_Name LIKE 'u'
INTO :DonorLName_at
End SQL
Any way to modify the SQL query so that it works like the 4D query without
specifying each and every specific Unicode character that I want to search for?
David
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
