Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010
    Posts
    2

    Unanswered: Search multiple keywords

    Been trying to solve this for ages and still getting no where
    Last edited by yokozuma; 01-27-10 at 05:37.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You either need some server side processing to split your string or you can use table valued parameters (required SQL Server 2008 and a client side language that supports them, such as the .NET family).
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Or you could use dynamic SQL with an IN() clause, but that is typically considered bad practice.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Jan 2010
    Posts
    2
    Quote Originally Posted by pootle flump View Post
    Or you could use dynamic SQL with an IN() clause, but that is typically considered bad practice.
    Thanks. What's the easiest way to go about doing that?
    Last edited by yokozuma; 01-27-10 at 05:37.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •