Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Talking Unanswered: Suppressing Errors

    Hi There, Can anybody help,

    I am trying to suppress the following error message in a stored procedure:

    Server: Msg 245, Level 16, State 1, Procedure usp_import_CLIS, Line 237
    Syntax error converting the varchar value 'ABCD' to a column of data type int.

    Tried using SET ANSI_WARNING OFF with no luck, has anyone any ideas?
    It would be much appreciated!!

    THANKS Mel !

  2. #2
    Join Date
    Jul 2002
    Village, MD
    I am not sure that you can suppress this error but it possible to avoid it is by using a function isnumeric() .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts