Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • 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: *

  1. ricka0

    MS SQL: duplicates with DISTINCT

    T-SQL deals with ASCII strings Yes, and unicode too. See nvarchar
  2. ricka0

    MS SQL: duplicates with DISTINCT

    I suppose you could argue that, but SQL also lets you specify the language you are using. That same arguement applies double to Java, C#, C++ etc, yet their Trim functions remove whitespace of the character set installed. It's such a common problem every high level language has the Trim methods...
  3. ricka0

    MS SQL: duplicates with DISTINCT

    Nope. I figured out the problem is: RTRIM Returns a character string after truncating all trailing blanks. But I don't have blanks, I have '\r\n' apparently there is no T-SQL function to remove white space.
  4. 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...

Part and Inventory Search

Back
Top