CONCAT function ignores NULLs: SELECT CONCAT(LEFT(LastName, 1), ‘,’ , LEFT(FirstName, 1), ‘ ‘ + LEFT(MiddleName, 1)) theNameWithInitials FROM myTable If you use CONCAT, you will not need to worry about whether LEFT(X) is null or not.
Tag: left
How to add some content to the right side of CardHeader on Bootstrap
<div class=”card-header container-fluid”> <div class=”col-md-10″><h3>Your Header Title</h3></div> <div class=”col-md-2 float-right”>The content you want to add to the right side.</div> </div>
CSS Padding and Margin 4 Values and What happens if some of them are omitted
CSS Padding The CSS padding properties are used to generate space around an element’s content, inside of any defined borders.