Sorting programmatically 1

[serializer]

I have a table that consists of emails. As you know email consists of prefix@domain.extension. I wonder if it is possible to construct and sql thats sorts on the domain name and forward? For example:

xerxes@domainA.com
alpha@domainB.com

thanks!

 

[SgtJarrow]

Something like below should do the trick. Couple of notes: This assumes only ONE at-symbol (@), and This assumes you only want to sort based on the domain name as a whole.

DECLARE @Addresses AS TABLE
(
	EmailAddress			VARCHAR(100)
)

INSERT INTO @Addresses (EmailAddress) VALUES ('rjohnson-remove@ultimatemedical.edu')
INSERT INTO @Addresses (EmailAddress) VALUES ('rjohnson2-remove@ultimatemedical.edu')
INSERT INTO @Addresses (EmailAddress) VALUES ('rjohnson-remove@somewhere.com')
INSERT INTO @Addresses (EmailAddress) VALUES ('lhurgoyf-remove@tampabay.rr.com')
INSERT INTO @Addresses (EmailAddress) VALUES ('wildmage-remove@tampabay.rr.com')
INSERT INTO @Addresses (EmailAddress) VALUES ('robert.johnson-remove@tampabay.rr.com')

SELECT
	EmailAddress
	, SUBSTRING(EmailAddress, CHARINDEX('@', EmailAddress) + 1, 1000) 'DomainName'
FROM @Addresses
ORDER BY
	SUBSTRING(EmailAddress, CHARINDEX('@', EmailAddress) + 1, 1000)
	, EmailAddress

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
C#.NET Programmer

 

[serializer]

Perfect, thanks!