The Final and Finest Answer is select name form product where name like %foo% and len(name)<=6 ;
length should be the <=6 because of constraints ..given that 50% and more foo can occure anywhere in word as footba probability of occurance of foo is 50% byfoot foofoo 100% its wouldn't give result for word fo,fuo,fou etc..i think this is good..xplaination but about word footbal , food,fool .....these also similer having foo but don't have len<=6 which our contraints right me if i m wrong Regards Shashank -- You received this message because you are subscribed to the Google Groups "Algorithm Geeks" group. To post to this group, send email to algoge...@googlegroups.com. To unsubscribe from this group, send email to algogeeks+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/algogeeks?hl=en.