I'm only starting out but I reckon that to use a CASE within a select statement might give you the ability to select books with titles where the case is true that the title begins with<br>
Case Title_name like A%<br>
Case Title_name like The%<br>
<br>
and so on.<br>
You could then re-store the...
Thanx guys,<br>
My problem is slightly more complex because the data from the DB is usually only accessed via a third party front end pre-written in power builder, ( MainSaver ).<br>
This means that I cannot create new views as my clients only ever see the output generated by MainSavers fixed...
How can I re-order an existing column into alphabetical order.<br>
I have a client accessing a server based Oracle database and the retrieved data is always in the order that it was enetered in originally. This makes life difficult for the user who would prefer to see it in alphabetical order.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.