CLR for sql server 2005

[aas4mis]

I know this is C#, but thought the SQL community would know better. I'm trying to get a CLR compiled to handle a Double.TryParse() via TSQL and the code won't compile.

I'm no C# guru, found this code on the web when looking for a way to try_parse in earlier versions of sql (2005).

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
 
namespace ClassLibrary1
{
    public class Class1
    {
        [SqlFunction]
        public static SqlDouble TryParseDouble(SqlString str) 
        { 
                Double d; 
                bool success = Double.TryParse(str, out d); 
                if (!success)     
                       return SqlDouble.Null; 
                return new SqlDouble(d); 
        } 
    }
}
 

The underlined is where my issue is. Here is the error.

Error    1    The best overloaded method match for 'double.TryParse(string, out double)' has some invalid arguments    c:\xxxxx\Class1.cs    16    32    ClassLibrary1
Error    2    Argument 1: cannot convert from 'System.Data.SqlTypes.SqlString' to 'string'    c:\xxxxx\Class1.cs    16    48    ClassLibrary1
 

Any help on the matter would be appreciated, i'm ready for an easier way to convert varchar to decimal(18,8) and not break on errors to be expected.

Thanks!

[aas4mis]

Nevermind.. :) Looks like the 'str' inside of the Double.TryParse() needed to be 'str.Value'. I'll load this into sql and post back if it works.

Thanks!

(you know, it's bad enough to talk to ones self, but to answer ones self??).. Programmers

[Rabbit]

Why not use the ISNUMERIC() function that's available in T-SQL?