SQL From Zero to Hero in 30 Days — Day 6 Working With Text
Learn, practice, master.
The links below will be updated as we progress into the series:
- Day 1: Introduction
- Day 2: The Select
- Day 3: Filtering
- Day 4: The Group by
- Day 5: Expanding the Group by
- Day 6: Working With Text
- Day 7: Working With Text 2
- Day 8: Date Manipulation
Welcome to day 6 of this series!
Data does not always come in plain numbers. We quite often need to deal with textual data. Thus, any data analysis tool is supposed to provide functions and methods to work with text.
In this article, we will go over some SQL functions for manipulating textual data.
Note: Although the SQL syntax is mostly the same in different RDBMSs, there are some minor differences. Thus, it is important to emphasize that we will be using Microsoft SQL Server as RDBMS in this series.
Let’s start by creating a sample table and inserting dummy data into it.
We can create a table by using the create table statement. Table name, column names, and associated data types must be declared.
