Adding options to Parameters

• Tarakq

  SSC Journeyman

  Points: 75

  More actions

  March 6, 2011 at 9:37 pm

  #233008

  Hi Guys,

  I want to add few filter options such as begins with, contains, ends with to the parameters.

  I attached a screen shot of it.

  In advance, I appreciate your help.

  

• bulbanos

  Ten Centuries

  Points: 1049

  More actions

  March 8, 2011 at 1:18 am

  #1295719

  I don't know even know if that works but it's worth a try.

  If you add a case statement to the start of your stored procedure like

  case when @Filter = 1 then select @Search = '%' + @Search

  when @Filter = 2 then select @Search =@Search + '%'

  ... end

  I'm not sure of the syntax, but you get the idea of appending a wildcard character.

  Then use it in your query:

  ... where SearchField LIKE @Search

  ---

  
  My LinkedIn profile