June 2021 - All Things SQL

SQL LENGTH – Finding Max & Min String Width

max length sql, min length sql, select max length of column in sql, select max length sql, sql max length, sql min length, sql string max length

We can use a combination of the MAX and MIN functions in conjunction with the SQL length function to get

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