Link Search Menu Expand Document

LTRIM

Removes all consecutive occurrences of common whitespace (ASCII character 32) from the beginning of a string. It doesn’t remove other kinds of whitespace characters (tab, no-break space, etc.).

Syntax

LTRIM(<target>)
Parameter Description
<target> The string to be trimmed.

Example

SELECT
	LTRIM('     Hello, world! ');

Returns:

Hello, world!