Cellwise · SQL track

Working with text

Change case, join and cut text.

SQL has text functions much like Excel’s. UPPER and LOWER change case, LENGTH counts characters, and SUBSTR cuts out part of a value.

To join text, SQLite and many other databases use two pipes: ||. It works like & in a spreadsheet.

What you’ll do

• Change to capitals
• Join text together
• Cut out part of a value
• Filter on length