Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Search results for query: *

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

    MS SQL: duplicates with DISTINCT

    SELECT DISTINCT LTRIM(RTRIM(queryParam)) AS qpTrimmed FROM queryParamValTbl has duplicates (it removes most duplicates) I assumed that scngs_zone scngs_zone was really 'scngs_zone' 'scngs_zone ' -- trailing whitespace So I tried the following: SELECT DISTINCT LTRIM(RTRIM(queryParam)) AS...
    • ricka0
    • Thread
    • Replies: 5
    • Forum: SQL

Part and Inventory Search

Back
Top Bottom