learn

SUBSTRING (Transact-SQL)

The SUBSTRING function returns a portion of a specified character, binary, text, or image expression.
note

SQL SUBSTRING behavior across various DBs, including Tsurugi

SUBSTRING is a standard SQL function used to extract a portion of a string. It is defined in ISO/IEC 9075 (commonly known as ISO SQL) and is supported by many database products. SUBSTR is an SQL ...
learn

Functions. Substring(Column, Int32, Int32) メソッド

このブラウザーはサポートされなくなりました。 Microsoft Edge にアップグレードすると、最新の機能、セキュリティ更新プログラム、およびテクニカル サポートを利用できます。 一部の情報は、リリース前に大きく変更される可能性があるプレリリースされ ...
GitHub

SQL -Substring & RegEx Functions.sql

--- It aims to support SQL users to smartly retrieve data to support data professionals. --- Context: Databases have the data stored in an organized manner. However, we may come across situations ...
GitHub

From SQL to SPL：Substring from a column of strings

105009400068600 WNr1.4112 Inox Rund 8.00 mm nach EN 10088-3 + A+C+SL, gesch 105009400068700 WNr1.4301 Inox Rund 36.00 mm nach EN 10088-3, geschliffen, T 105009400068800 WNr1.4104 Inox Rund 25.00 mm ...
Ars Technica

T-SQL, order by substring?

Is it possible to order by a substring in a returned field? I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...