LTRIM and RTRIM function of SQL server helps to truncating leading and trailing blanks space respectively. If we combine both the function together, we can truncate leading and trailing blanks space of any specific word.
Example:
- Select LTRIM(RTRIM(' Jignesh '))
Output:
Jignesh