SQL Functions Overview

SQL Functions Overview — Comprehensive overview of string, numeric, date, window, and advanced functions in SQL. The guide walks through String Functions, Numeric Functions, Date/Time Functions, Window Functions. CONCAT() joins strings. SUBSTRING() extracts parts of a string. LENGTH() returns character count. REPLACE() substitutes text. TRIM() removes whitespace. UPPER()/LOWER() change case. INSTR()/CHARINDEX() find positions. REGEXP allows pattern matching with regular expressions. ROUND() rounds numbers. ABS() returns absolute value. CEIL()/FLOOR() round up/down. POWER()/SQRT() powers and roots. MOD() returns remainder. RAND() generates random numbers. SIGN() returns -1, 0, or 1. TRUNCATE() truncates without rounding. The guide is organized into 4 sections that build on each other, each pairing a prose explanation with real SQL you can run as-is. Related guides: SQL Introduction, SELECT Statement, WHERE Clause & Operators, SQL JOINs, GROUP BY & Aggregation. This is one of 25 SQL guides on SQL Reference — see the full list on the guides page.