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 ...
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 ...
IEEE

Efficient processing of substring match queries with inverted q-gram indexes

Abstract: With the widespread of the internet, text-based data sources have become ubiquitous and the demand of effective support for string matching queries becomes ever increasing. The relational ...
note

[Practice! SQL] String Manipulation Part 1 (SUBSTR / CONCAT)

Extracting categories from product codes, getting domains from email addresses, concatenating multiple values for labels—string processing is a daily occurrence. First, it is recommended to organize ...
GitHub

translate-sql-string.R

#' implementing a new backend. They are typically used within [sql_translator()] #' to define how R string functions should be translated to SQL. #' * `sql_substr()` creates a SQL substring function ...
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 & ...
GitHub

Postgres: substring generates numeric arguments instead of integer

library(dbplyr) translate_sql(substring('abcdefghijklmno', 6,7)) #> Expected: <SQL> substring('abcdefghijklmno', 6, 7) #> Actual: <SQL> substring('abcdefghijklmno', 6 ...