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

Sorting tool for semantic versions

This repo is about how to sort semantic versions in SQL. By Semantic Versioning 2.0.0 format X.Y.Z Semantic Versioning 2.0.0: V1.10.1 or V1.2.0. Usual SemVer sorting for module, versions in ...