SELECT BETWEEN 'a' AND 'd' - problem
Hello, Shantanu Oak once helped me out with this syntax,
and it's working, but now I have another problem.
There are special symbols in my native language (latvian).
You can see these symbols here:
http://lab.serveris.lv/abc.jpg
So how should I change the syntax to solve the encoding (windows-1257) problem?
Is it possible?
SELECT * FROM table WHERE LEFT(lower(names), 1) BETWEEN 'a' AND 'd' ORDER BY names
Thanks a lot,
Lab.
Subject
Written By
Posted
SELECT BETWEEN 'a' AND 'd' - problem
April 12, 2005 07:22PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.