I'm guessing you have to loop through all the records and instr one at a time. or?
> i got stuck with a problem while trying to use Instr Function in a > querry, what i want to get all the Records containg a particular > string in a sprcified field and then display them in MSHFlex Grid. > > I m trying to use > Exp1: Instr(1,<field name>,"test") > for my database that is > Exp1: Instr(1,[name],"test") > here name is the field name. > > but what i m getting is the first record ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
