I have a column with this data:
How to select this registry? I tried this
SELECT * FROM ADDRESS WHERE CITY_NAME = "DIAMANTE D'OESTE";
but it din't work... thanks ;)
Solved! Go to Solution.
The outer quotes must be single ' and the embedded quote is escaped by entering two in a row:
SELECT * FROM ADDRESS WHERE CITY_NAME = 'DIAMANTE D''OESTE';