GitHub

SQLQuery11(STRING-SUBSTRING).sql

--NOTE- IT WILL HELP BCZ PEOPLES NAME'S STARTING CHARACTER WILL MATCH BCZ SO MANY USE SHORT NAME INSTEAD OF LONG ...
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 ...
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 & ...
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 ...