how to eliminate a blank character

Question

hi there, i want to eliminate a blank character at the begin from a string in a nvarchar field   for ejample in this precio field, i don't want to have a space blank at the beginning of the string:          Thanks

Farhan Ahmed · Answer

The LTRIM function is used to remove any white spaces from the beginning of a string.
LTRIM(String)
The RTRIM function is used to remove any white spaces from the end of a string.
RTRIM(String)
Example:
SELECT LTRIM(' spaces at start')
SELECT RTRIM(spaces at end ')