LinkedIn

SQL Server: Hidden skills of TRIM function

LTRIM and RTIRM functions can cut leading (LTRIM) or closing (RTRIM) whitespaces from a string in SQL Server. If we want to clean the both beginning and ending of a string then we have to combine them ...
GitHub

trim-function-in-sql-server.md

This function is used to omit space characters or some additional given characters from the beginning or end of the character string. This function accepts specific characters and strings. By default, ...
LinkedIn

Data quality checks in SQL: TRIM, NULLIF, ISNULL, COALESCE

SQL_7 Some data quality checks... For Extra Spaces => Empty Strings 1-TRIM For Empty String => Nulls 2-NULLIF For Nulls => Unknown 3-ISNULL, COALESCE Now your data is ready to join, or aggregate ...
makeuseof

SQL String Functions: 10 of the Most Useful

Sandra is a Tech enthusiast with a Journalism and Full-stack web development background. She specializes in web development and Cloud technology. For leisure, Sandra enjoys a good thriller, hugging ...