Using Variable in PATINDEX keyword

• kreskins

  Default port

  Points: 1429

  More actions

  March 10, 2003 at 11:09 am

  #105628

  I am using sql6.5

  Can I use a Variable such as @NAME inside of a PATINDEX statement in a SPROC? For example something like below:

  @NAME varchar(30)

  SELECT EXAMINER_ID

  FROM USER_GROUP

  WHERE PATINDEX('%@NAME%',EXAMINER_ID) > 0

  If so do I need the single quotes or the percentage signs?

  Kevin-

  Thanks For your continued Help.

  
  Thanks For your continued Help.

• mromm

  SSCarpal Tunnel

  Points: 4301

  More actions

  March 10, 2003 at 11:32 am

  #450711

  This would work:

  DECLARE @NAME varchar(30)

  SELECT EXAMINER_ID

  FROM USER_GROUP

  WHERE PATINDEX('%' + @NAME + '%',EXAMINER_ID) > 0

  Michael

• kreskins

  Default port

  Points: 1429

  More actions

  March 10, 2003 at 11:50 am

  #450713

  Thanks, that worked perfectly....

  Thanks For your continued Help.

  
  Thanks For your continued Help.