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.
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/
for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter
.Cross Tabs and Pivots, Part 1 – Converting Rows to Columns Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs Understanding and Using APPLY (Part 1)Understanding and Using APPLY (Part 2)