Home Forums SQL Server 2008 T-SQL (SS2K8) Conversion from varchar to strong data types RE: Conversion from varchar to strong data types

  • March 21, 2013 at 8:17 am

    #1599402

    Drammy (3/21/2013)

    Thanks for the quick reply.

    And thanks for the suggestion with the money data type.

    I understand what ISNUMERIC is used for; that was just an example.

    I was just trying to save time and was hoping someone would know of existing functions in the community that produce the same results as TRY_CONVERT but for 2005, 2008 and 2012...

    If 2005 or 2008 had it, you would probably managed to google it out, but...

    No, there is none in pre-2012 versions.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]