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 TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ricka0
-
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...
