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:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to