a syntax error

• nazaninahmady_sh

  Default port

  Points: 1465

  More actions

  December 13, 2010 at 12:46 am

  #244313

  ((@VarEmp_Id=0) or (@VarEmp_Id is null)or (Employee.Emp_Id=@VarEmp_Id)) And

  (Emp_Name=Case @VarEmp_Name is not null Then @VarEmp_Name Else Emp_Name)And

  ((@VarEmp_Surename='') or (@VarEmp_Surename is null)Or freetext(Emp_Surename,@VarEmp_Surename ))And

  i wrote this tsql line , in second line , about Emp_Name,

  something is wrong, and that is a syntax error , that is about

  is not null

  or

  Incorrect syntax near '@VarEmp_Id'.

  would you please help me?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  December 13, 2010 at 2:00 am

  #1261565

  This should do:

  (Emp_Name=Case when @VarEmp_Name is not null Then @VarEmp_Name Else Emp_Name end)And

  Hope this helps,

  Gianluca

  -- Gianluca Sartori

• Abhijeet Chavan

  SSCommitted

  Points: 1511

  More actions

  December 14, 2010 at 3:34 am

  #1262094

  U missed an 'END' for case in second line.