note

SQL,SUBSTRING各種DBの挙動、Tsurugiもあるよ

SUBSTRING は、文字列の一部を抽出するための標準SQL関数です。ISO/IEC 9075（通称ISO SQL）で定義されており、多くのデータベース製品でも対応しています。 SUBSTRINGはDBによって挙動が違います。いや少し語弊があるかもしれません。SUBSTRING('abcde' FROM 3 FOR 2)のよう ...
Ars Technica

T-SQL, order by substring?

Is it possible to order by a substring in a returned field?<BR>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 ...
GitHub

Mastering SQL Extract Function for Data Transformation and Analysis Free Download!.md

Data is the lifeblood of modern businesses, and SQL is the language used to access and manipulate it. Among the many powerful features SQL offers, the ability to extract specific parts of data using ...
Ars Technica

You ugly (SQL, Substring, multiple charindex occurrences)

I'm having to hack a report together to pull data from another field in the same table. The row selection is going to be based on various elements in the above 'foreignkey' field - elements 1, 2, 4 & ...