LIKE

Hi
Can I use LIKE in ORDER BY ?
If yes then please example.
Thanx

you order according to a column or expression you are querying, and the like only appears in the while clause, never in any other place ...

You could order using SUBSTR e.g.

select * from emp
order by substr(ename,2)

But ordering by like is totally meaningless.

This question would be more appropriate under development rather than in the administration Forum. So I'm moving it to the development forum...

Sam