How to Use the LOWER() Function in SQL Server: A Detailed Guide

Syntax:

<span class="pln">
LOWER</span><span class="pun">(</span><span class="typ">Character_Expression</span><span class="pun">)</span><span class="pln">
</span>

Converts all the characters in the given Character_Expression, to lowercase letters.

Code:

<span class="pln">
</span><span class="typ">Select</span><span class="pln"> LOWER</span><span class="pun">(</span><span class="str">'CONVERT This String Into Lower Case'</span><span class="pun">)</span><span class="pln"> 
</span>

Output:

The above code will produce the following result-

<span class="pln">
convert </span><span class="kwd">this</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="kwd">into</span><span class="pln"> lower </span><span class="kwd">case</span><span class="pln">
</span>