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

REGEXP_SUBSTR returns one occurrence of a substring of a string that matches the regular expression pattern.

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

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

These are functions like TRIM (), QUOTE (), SUBSTR (), HEX (), LOWER (). If we want to follow ANSI SQL, we have to: disallow using other types for args which supposed to be string. String and binary ...

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