Those specific examples you gave will work fine for that query, however, the problem is that somewhere in your data, you have something that doesn't work.

You could filter those results out in your where clause (see below), however, I would suggest maybe selecting those results out first, and seeing if they need addressing themselves. This will return your bad rows:
WHERE CHARINDEX('.', MachineName) = 0