SQL Functions Archives - 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

SQL String Length – Finding Column Width

length of a string in sql, sql string function, sql string length, sql string width, string function sql, string length sql, string width sql

To find the string length (or width) in a field we can use the sql length function. The specific syntax

SQL TRIM Functions – Remove Blanks & Whitespace

remove blanks in sql, removing blanks in sql, removing whitespace in sql, sql remove blanks, sql remove whitespace, sql removing blanks, sql removing whitespace, sql trim all spaces, sql trim function, sql trim whitespace, trim function sql, trim spaces in sql

Often times, data is not cleansed appropriately when pulling data from files or other database tables. As a result, this

SQL CAST & CONVERT Function – Modifying Data Types

cast function sql, cast int to varchar sql, cast varchar to int sql, convert vs cast sql, sql cast function, sql cast int to varchar, sql cast varchar to int, sql cast vs convert

There are a few ways (depending on the database) where we can convert a column data type. The main two

SQL LEAD() Function – Getting Next Value

sql function lead, sql function next value, sql lead example, sql lead function example, sql next value, sql server lead function, sql window lead

Very similar to the Lag() function that provides a previous record value is the Lead() function which provides the opposite

SQL LAG() Function – Getting Previous Value

sql function lag, sql function previous value, sql lag example, sql lag function example, sql previous value, sql server lag function, sql window lag

There are several functions in SQL that are very useful such as the Lag() and Lead() functions. The lag function