Re: Like - problems

At 04:17 PM 9/22/2004, you wrote: Hello there, I was wondering how I could make a specific type of search when the string has more than one word. Ex.- String = "Green Apple" Select * from fruits where (fruits.color like '%Green Apple%' or fruits.type li

Like - problems

Hello there, I was wondering how I could make a specific type of search when the string has more than one word. Ex.- String = "Green Apple" Select * from fruits where (fruits.color like '%Green Apple%' or fruits.type like '%Green Apple%') -