(no subject)

[swolfe]

any SQL nerds know a better way to do this:

reverse(substring(reverse(gf.strGameDLL), charindex('.', reverse(gf.strGameDLL))+1, 999))

I have a field that may or may not have a '.DLL' on the end that I want to strip off. This is on a SQL Server...so T-SQL.

EDIT: what i have above works, but seems pretty inefficient