To remove the left space from a string uses sql LTRIM function. The LTRIM function delete spaces from the left of the string.
Syntax
LTRIM ( character_expression )
Example
SELECT LTRIM(' Test') AS Result;
| Result |
|---|
| Test |
Example
DECLARE @var_string varchar(100);
SET @var_string = ' Test remove the left space.';
SELECT LTRIM(@var_string);
GO
| Result |
|---|
| Test remove the left space. |