How about an SQL string? Select * From TableName Where FieldName Like '*test*' or FieldName Like test*' or FieldName Like '*test'
This is written assuming you are using Access databases. Rick Rose -------Original Message------- From: .rEs Date: 10/24/04 14:23:01 To: [EMAIL PROTECTED] Subject: Re: [vbhelp] Instr Help Required 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 . [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
