How to Use the LEFT() Function in SQL Server: A Complete Guide
☰Fullscreen
Syntax:
<span class="pln"> LEFT</span><span class="pun">(</span><span class="typ">Character_Expression</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Integer_Expression</span><span class="pun">)</span><span class="pln"> </span>
Returns the specified number of characters from the left hand side of the given character expression.
Code:
<span class="pln"> </span><span class="typ">Select</span><span class="pln"> LEFT</span><span class="pun">(</span><span class="str">'ABCDE'</span><span class="pun">,</span><span class="pln"> </span><span class="lit">3</span><span class="pun">)</span><span class="pln"> </span>
Output:
The above code will produce the following result-
<span class="pln"> ABC </span>
No Questions Data Available.
No Program Data.