Timeline for Trim Trailing Whitespace, Tab, Newline, Carriage Returns, etc
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 15:31 | comment | added | Pete Alvin | For left version this fixes it: SET @Input = RTrim(@Input) | |
| Jan 7, 2020 at 15:25 | comment | added | Pete Alvin | Thank you, but there is a bug in each routine: they malfunction if there are trailing spaces, because LEN excludes trailing spaces. Perhaps either RTrim first or use DATALENGTH (but beware of double length due to encoding). | |
| May 4, 2016 at 7:46 | history | edited | Martin Smith | CC BY-SA 3.0 |
Added USP to answer
|
| May 3, 2016 at 17:23 | history | answered | Gordon Bell | CC BY-SA 3.0 |