Home Forums SQL Server 2008 T-SQL (SS2K8) Problem with CAST to VARCHAR with SUBSTRING Function RE: Problem with CAST to VARCHAR with SUBSTRING Function

  • January 21, 2013 at 9:52 am

    #1579315

    Welsh Corgi (1/21/2013)

    Thanks. Not sure why I'm getting an error on the substring function.

    Msg 8116, Level 16, State 1, Line 1

    Argument data type numeric is invalid for argument 1 of substring function.

    Perhaps it is because an integer value does not implicitly convert to a character string.

    You may do well to reread that first article you reference in your own signature block and follow the advice in it.