Home Forums SQL Server 2008 SQL Server 2008 - General SUBSTRING and CAST Help Required RE: SUBSTRING and CAST Help Required

  • December 5, 2013 at 2:53 am

    #1670969

    Hi,

    Try the switching the order of substring/cast i.e.

    SELECT CAST(SUBSTRING(ID,3,LEN(ID)) AS bigint) AS ID FROM table