Viewing 2 posts - 1 through 2 (of 2 total)
I used following to remove only trailing white spaces in a CHAR(30) column:
RTRIM(LTRIM(CAST(City_Id As VARCHAR(30)))) AS City_Id
Piyush Varma
October 3, 2012 at 12:49 pm
#1545160
Re: Super Fast DISTINCT using CTEs - by Paul White
Hi Paul,
How can I extend your technique to multiple VARCHAR columns please?
Any clues please?
Thank you,
Piyush
July 23, 2012 at 12:14 pm
#1516410