Syntax error(156) in UDF

• hellsgate

  Grasshopper

  Points: 21

  More actions

  August 15, 2007 at 2:10 am

  #153747

  Hey folks,

  I'm receiving the following error message when I check the syntax of my UDF:

  Error 156: Incorrect syntax near the keyword 'SET'.

   

  Here is the UDF which is producing the error:

  CREATE FUNCTION dbo.FnIsStandard (@Fname as VarChar(50)) 

  RETURNS Char(2) AS 

  BEGIN

   Declare @res Char(2)

   IF IsNumeric(SubString(@Fname, 1, 2))

    SET @res=SubString(@Fname, 1, 2)

   Return @res

  END

  I've looked through the BOL and checked articles like this and I can't see where I've got the syntax wrong.  Can anyone help me out or point me in the right direction?

   

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  August 15, 2007 at 2:46 am

  #726978

  IF IsNumeric(SubString(@Fname, 1, 2)) = 1

  _____________
  Code for TallyGenerator

• hellsgate

  Grasshopper

  Points: 21

  More actions

  August 15, 2007 at 3:01 am

  #726980

  Brilliant Sergiy, that fixed it.  Thanks very much