ORDER BY a value in a string

I'm having a little trouble with sql order by. I have a a column that has values of:

Gillite.Qutz
Tom.Goo
Jill.Hank
Joseph.Cool

I want to be order by their last name, which is after the period:

Joseph.Cool
Tom.Goo
Jill.Hank
Gillite.Qutz

How would I go about doing that? Thanks!


Sunny B.

Try this:

SELECT TheName
FROM tblDeleteMe
ORDER BY SUBSTRING(TheName, CHARINDEX('.', TheName) + 1, LEN(TheName) - CHARINDEX('.', TheName))

Thank you! That worked great!