Sean Lange (4/15/2013)

---

Well you could create your own IsAlpha. I would extend the version you found to at least include spaces and periods.

something like this might help you along.

declare @ScalarVal varchar(100) = '123.'

select case when @ScalarVal not like '%[^a-z0-9 .]%' then 1 else 0 end as IsAlpha

You could turn that into a function if you wanted.