ramadesai108 (6/3/2009)
Hi Bob,Converting the results to VarChar did fix it. Thanks for your help.
Now you are doing a lot of extra work. After your IsNumeric check, just return the value instead of converting it to an int. When the IsNumeric returns 0, and you are returning a zero, return a '0' instead.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes