Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mailtome
  • Content: Threads
  • Order by date
  1. mailtome

    Sorting a column

    Hi I have the following query select SUBSTRING_INDEX(m.FileName, '/', -1) as ShortFileName from modifications m order by ShortFileName ASC; The output of the query is +------------------------+ | ShortFileName | +------------------------+ | CTKAction.java | | CTKView.java...
  2. mailtome

    Sorting a column

    Hi I have a varchar column say Issue with data as follow 900 1100 update test 800 Now I want to sort this column but the sort by query sorts it like 1100 800 900 test update Can anyone tell me the correct way to sot this column

Part and Inventory Search

Back
Top