Passing a where clause to an SP

• Mark Anderson-446267

  Mr or Mrs. 500

  Points: 545

  More actions

  June 1, 2007 at 5:36 am

  #174467

   

  Hi All

   

  I'm writing a SP that will search all columns in a table. The search criteria will vary a lot (sometimes an exact case-sensitive match is required, sometime I want to use a like clause and sometimes an in clause), so I want to be able to pass the where clause as a parameter. Fro example:

  EXEC FindAll " like '%ABC%' "

  EXEC FindAll " in ('ABC', 'DEF', 'GHI') "

  EXEC FindAll "= 'ABC' "

  Can soemone give me a hint of how I can escape the quotes, commas, etc.?

  I'm using SQl Server 2005

  Thanks

  Mark

• Camilo Torres

  SSCrazy

  Points: 2034

  More actions

  June 1, 2007 at 11:38 am

  #710401

  http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

  You can also load the list into a @temptable and join to it when building your @SQLCommand