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 gkittelson 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: eli22
  • Order by date
  1. eli22

    sort numerically by character string in query

    Thanks everyone!
  2. eli22

    sort numerically by character string in query

    Olaf you have mentioned the issue which must be the problem I have when trying the order by that Mike & Ez suggest, because their queries give me "order by clause is invalid" So you're right I'd rather not have to bring 2 columns into the results but that seems to be what works. And the data...
  3. eli22

    sort numerically by character string in query

    Hi. I have a field which might come in as a numeric but it's usually character. It might have numbers in it. And I use that field to define groups for processing. Until now this has been my query to define the groups SELECT myfield FROM mytable GROUP BY 1 But when there are many...

Part and Inventory Search

Back
Top