Thanks for the comments!! The UDF wasn't intended to be an all encompassing way to determine if a number could be converted to int. The UDF was merely a way to demonstrate how to use PatIndex effectively.
My blog: SQL Soldier[/url] SQL Server Best Practices: SQL Server Best Practices Twitter: @SQLSoldier My book: Pro SQL Server 2008 Mirroring[/url] Microsoft Certified Master: SQL Server, Data Platform MVP Database Engineer at BlueMountain Capital Management[/url]