sqlcmd.net validated sql reference

Tag archive

#text

Commands grouped around the same concept, pattern, or recurring problem.

10 commands with this tag Browse related patterns quickly
intermediate string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Assemble A Key/Value String

Format several known values into one compact `key=value` string for transport or handoff.

beginner string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Change Text Case With UPPER And LOWER

Convert string values to all uppercase or all lowercase using `UPPER` and `LOWER`.

intermediate conversion MySQL MariaDB SQL Server PostgreSQL SQLite

Encode Text As Base64

Turn one plain-text payload into a base64 string for transport or lookup.

intermediate string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Extract Part Of A String With SUBSTRING

Return only part of a text value by position and length.

beginner filtering MySQL MariaDB SQL Server PostgreSQL SQLite

Filter Text Case-Insensitively

Compare normalized text values with LOWER or UPPER so matching does not depend on stored capitalization.

beginner string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Get The Length Of A String

Return the number of characters in a string using `LENGTH` or `LEN`.

beginner string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Join Strings With CONCAT

Combine multiple text values into one string in the query result.

beginner string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Join Text Values With Hyphens

Combine multiple text values into one hyphen-separated key-like string.

beginner string-manipulation MySQL MariaDB SQL Server PostgreSQL

Repeat or Reverse a String

Use `REPEAT` to duplicate a string a given number of times, and `REVERSE` to flip its character order.

beginner string-processing MySQL MariaDB SQL Server PostgreSQL SQLite

Replace Text Within A String With REPLACE

Substitute all occurrences of a substring with a new value using `REPLACE`.