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!
-
MS SQL: duplicates with DISTINCT
T-SQL deals with ASCII strings Yes, and unicode too. See nvarchar -
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... -
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. -
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...
