Which function removes only the leading spaces from a string?

TheLTRIM()function in SQL removesleading spaces(spaces at the beginning of a string) while keeping spaces at the end.

Example Usage:

sql

SELECT LTRIM(' Hello World') AS TrimmedText;

Output:

bash

'Hello World'

Why Other Options Are Incorrect:

Option B (LEFT) (Incorrect):Used for extracting a portion of a string. Example:

sql

SELECT LEFT('Hello World', 5); -- Output: 'Hello'

Option C (TRIM) (Incorrect):Removesboth leading and trailing spaces, not just leading ones. Example:

sql

SELECT TRIM(' Hello World '); -- Output: 'Hello World'

Option D (REPLACE) (Incorrect):Replaces occurrences of one substring with another but doesnot specifically remove spaces.

Thus, the correct answer isLTRIM(), which removes onlyleading spaces.