July 2021 - All Things SQL

SQL Replace Function – Swapping Words & Characters

how to replace strings in sql, replace function in sql, replacing strings in sql, sql replace function, sql replace strings, sql replacing strings

Using the replace function in SQL can be useful to swap out words or characters with others. As an example,

SQL Substring – Selecting Specific Field Data

sql query substring, sql substring, sql substring function, substring function in sql, substring sql, substring sql query

We can write a SQL query using the substring function to select the exact pieces of information needed in a

SQL – Converting Strings to Upper & Lower-Case

lower upper sql, sql lower upper, sql upper lower, upper lower sql

In order to convert character or string columns in SQL to UPPER or LOWER case we need to know the