How to remove Spaces Left and Right side of Strings
- MS Sql Server
- 855
- March-27-2018
- by Rizwan Saqib
Left Trim& Right Trim
Definition
The LTRIM & RTRIM function removes leading spaces from a string.
1 Left Trim
1.Select (‘ Hello’)
There is a Multiple Spaces in the left side of string if we want to remove it we use [Left trim] Write this Function
Select LTrim (‘ Hello’)
When we Execute its return like this [Hello]
2.Right Trim
There is a space in Right side of “Hello ” use R trim Query to remove the space like this
Select Rtrim (‘Hello ’)
When we Execute its return like this [Hello]
