Is this possible to use LIKE ALL in SP.

• abcim

  SSC Eights!

  Points: 879

  More actions

  June 11, 2011 at 1:02 am

  #237720

  Here is the my original old table look like,

  declare @a table (a varchar(500))

  insert into @a

  select 'a;b;c' union all

  select 'a;d;b' union all

  select 'c;a;e'

  My application is sending values in my SP as 'a;b' or 'b;c;a' etc,

  Now I need to Select only those Rows in table @a which have a and b or b and c and a[/b]. I am using split function in my SP to make user input as table.

  I have also posted this question to,

  http://stackoverflow.com/questions/6310417/is-this-possible-to-use-like-with-all-keyword

• WayneS

  SSC Guru

  Points: 95460

  More actions

  June 11, 2011 at 1:28 am

  #1337358

  I think that this article will help you out: Delimited Split Function[/url]

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• abcim

  SSC Eights!

  Points: 879

  More actions

  June 11, 2011 at 3:46 am

  #1337361

  Thanks, Wayne. I got answer from here,

  http://stackoverflow.com/questions/6310417/is-this-possible-to-use-like-with-all-keyword