Directly on the code:
Select
Case
When the ' Workreport ' =ltrim (RTRIM (' Workreport ')) then ' trim to space success '
When ' Workreport ' =replace (' workreport ', ' ", ') Then ' REPLACE ' to space success '
When ' Workreport ' =replace (' Workreport ', char (ASCII (REPLACE (' Workreport ', ' workreport ', '))), "then" Use ASCII encoding to replace the space to succeed '
Else ' Go to space failed '
End
The operating result is:
Use ASCII encoding to replace the space to succeed
Explanation: The first two conditions in the case block are not blocked because the space here is not a regular space, you can use the ASCII function to get the ASCII code of the space, and then use the CHAR function to obtain the special space here according to the ASCII code, and finally replaced with the Replace function.
An issue in SQL Server where strings cannot replace spaces