Post reply

Try Convert is not working

  • February 27, 2015 at 3:09 am

    #314976

    Hi There,

    TRY_CONVERT is introduced in 2012. Following is my version,

    Microsoft SQL Server 2012 - 11.0.2100.60 (X64)

    Feb 10 2012 19:39:15

    Copyright (c) Microsoft Corporation

    Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    but when I try to use the this ,

    SELECT TRY_CONVERT(INT, '100')

    im getting

    'TRY_CONVERT' is not a recognized built-in function name.

  • February 27, 2015 at 4:52 am

    #1780521

    Works fine for me. Check the compatibility level of the database you are executing it in.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply