LIKE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: LIKE

  1. #1
    Join Date
    Aug 2001
    Posts
    134

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

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    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 ...

  3. #3
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    You could order using SUBSTR e.g.

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

    But ordering by like is totally meaningless.

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width