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

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

SQL SUBSTRİNG KULLANIMI.sql

select substring (FirstName , 1,5) from Person.Person where BusinessEntityID = 3 -- Person.Person tablosunda ki BusinessEntityID si 3 olanı bana getir. Id si 3 olanın Firstname kolonunun 1. ve 5.