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
Thanx Sam Life is a journey, not a destination!
Forum Rules