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!

  • Congratulations Mike Lewis 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: DainBramage
  • Order by date
  1. DainBramage

    Query of Query is sorting ALL-CAP names incorrectly.

    Um...if you use LOWER in the ORDER BY clause, it has no affect on the data or the way it's displayed, it just reads all records as lower case so you get an accurate comparison.
  2. DainBramage

    Query of Query is sorting ALL-CAP names incorrectly.

    1) What's the point in having a second query that just selects everything from the first query? It's a waste of time and resources. Now you have 2 sets of the exact same info. 2) Have you tried "ORDER by LOWER(LName)"?
  3. DainBramage

    Who gets the most CFML webspace for their $$$

    http://www.crystaltech.com/

Part and Inventory Search

Back
Top