Try Convert is not working

• vignesh.ms

  Hall of Fame

  Points: 3456

  More actions

  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.

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  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

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel