In this post, we will discuss how we can get trims values of a column in SQL server 2008.
Also, you can check out my previous posts on:
Suppose you have a column name as firstname of varchar type and if it contains any white spaces then when you run the select sql statement like below,
Select firstname from employees
Then it will return all the firstname of all the employees but also the whitespaces will come if any with the names.
so to trim the spaces you can write the select sql statement like below:
SELECT LTRIM(RTRIM(firstname)) AS FirstName from employees
This will trim the whitespaces from the column values.
Download FREE SharePoint 2019 Installation PDF Guide
This FREE PDF contains, Steps by step guide to install SharePoint 2019 Preview, prerequisites, hardware and software new features. First impression to SharePoint Server 2019 new modern site, modern lists and modern document libraries.
You May Also like the Following SharePoint Online Tutorials: