<div>
SQL Server/T-SQL:<br />
<br />
See <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/ltrim-transact-sql" rel="ugc">LTRIM()</a> and <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/string-functions-transact-sql" rel="ugc">T-SQL string functions</a>:<br />
<br />

<pre><code id="code-20-42451172-1">SELECT LTRIM(T.ExtraText) AS TrimmedExtraText
FROM   Transheaders T;</code></pre>
<br />
In MySQL: See <a href="https://dev.mysql.com/doc/refman/5.7/en/string-functions.html" rel="ugc">string functions</a>. It's also <a href="https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_ltrim" rel="ugc">LTRIM()</a>.<br />
<br />
And same for Oracle/PL-SQL (<a href="https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions083.htm" rel="ugc">LTRIM()</a>).
</div>


SQL Server/T-SQL:

See LTRIM() [https://docs.microsoft.com/en-us/sql/t-sql/functions/ltrim-transact-sql] and T-SQL string functions [https://docs.microsoft.com/en-us/sql/t-sql/functions/string-functions-transact-sql]:



SELECT LTRIM(T.ExtraText) AS TrimmedExtraText
FROM   Transheaders T;


In MySQL: See string functions [https://dev.mysql.com/doc/refman/5.7/en/string-functions.html]. It's also LTRIM() [https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_ltrim].

And same for Oracle/PL-SQL (LTRIM() [https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions083.htm]).

<div>
Get this error:<br />
<br />
Msg 8116, Level 16, State 1, Line 1<br />
Argument data type text is invalid for argument 1 of ltrim function.
</div>


Get this error:

Msg 8116, Level 16, State 1, Line 1
Argument data type text is invalid for argument 1 of ltrim function.

<div>
Well, TEXT is a deprecated data type (since years). And most string functions cannot work on it. Cast it to the correct data type. In this case NVARCHAR(MAX).<br />
<br />

<pre><code id="code-20-42451182-1">SELECT LTRIM(CAST(T.ExtraText AS NVARCHAR(MAX))) AS TrimmedExtraText
FROM   Transheaders T;</code></pre>
p.s. why do you use still TEXT?
</div>


Well, TEXT is a deprecated data type (since years). And most string functions cannot work on it. Cast it to the correct data type. In this case NVARCHAR(MAX).



SELECT LTRIM(CAST(T.ExtraText AS NVARCHAR(MAX))) AS TrimmedExtraText
FROM   Transheaders T;

p.s. why do you use still TEXT?

<div>
Do you think this would work?<br />
<br />
UPDATE TRANSHEADERS SET ExtraText = LTRIM(ExtraText)
</div>


Do you think this would work?

UPDATE TRANSHEADERS SET ExtraText = LTRIM(ExtraText)

<div>
<div class="content wysiwyg-content">
Left Trim - Hello I am wanting to Left Trim a field in a SQL Table. Are you able to provide the script?<br />
<br />
The Table is called Transheaders and the data field is called ExtraText<br />
<br />
Thanks.
</div>
</div>


Left Trim - Hello I am wanting to Left Trim a field in a SQL Table. Are you able to provide the script?

The Table is called Transheaders and the data field is called ExtraText

Thanks.

Left Trim in SQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.