Another way, using Luis' sample data

SELECT name, rtrim(ltrim(isnull(parsename(' '+x.name+' ', 2), x.name))) as name2
FROM (VALUES('Luis.Cazares'),('Luis Cazares'),('Luis Cazares.'),('.Luis Cazares')) x(name);

Here's another one for your tests. I think it's a winner 😉

IF OBJECT_ID('dbo.workdayCalendar') IS NOT NULL
DROP TABLE dbo.workdayCalendar;

-- Wide enough...

Thin Crust. Very thin and cut into slices not squares. This kind of talk has not popular in Chicago but my dad's a New Yorker and he brainwashed me early...

The Data Tuning Adviser is going to recommend columnstore indexes for me? October 2nd can't come soon enough! </sarcasm>

It's cool to finally see some new T-SQL commands. TRIM and...