GitHub

Intermediate - String Functions.sql

#Now we have Left. Left is going to allow us to take a certain amount of strings from the left hand side. #Now let's look at ...
GitHub

VShethe/SQL---String-Function

CREATE TABLE books ( book_id INT NOT NULL AUTO_INCREMENT, title VARCHAR(100), author_fname VARCHAR(100), author_lname VARCHAR(100 ...
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 ...
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 ...