MY TSQL NOT WORKING...

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  October 27, 2009 at 12:49 am

  #212622

  Hi all

  DECLARE @SEARCH VARCHAR(50)

  SET @SEARCH = 'Alexan'

  IF (ISNUMERIC(@SEARCH) = 0)

  BEGIN

  SELECT * FROM INV_table WHERE AUTHOR LIKE CHAR(39)+'%'+@SEARCH+'%'+CHAR(39)) AS VARCHAR(100)

  END

  The like conditions is not working properly can you give me exact solutions

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  October 27, 2009 at 1:29 am

  #1071050

  Why do you need CHAR(39) there, remove them and anyway there is an extra closing parenthesis at the end

  ---------------------------------------------------------------------------------

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  October 27, 2009 at 2:04 am

  #1071058

  Thanks working fine,,,,,,,........