>Thanks Tamar for your reply.
>but this is bit prolem
> SET FILTER TO " " + ALLTRIM(ThisForm.bname.Value) + " " $ UPPER(bname)
>it does not locate first word ,locate only from between.
>like this"my name is my name"
>first"my" ignore and scond my locate
You can add additional clauses to the filter to check for first and/or last word
SET FILTER TO (" " + UPPER(ALLTRIM(ThisForm.bname.Value)) + " " $ UPPER(bname)) ;
OR (UPPER(LEFT(ALLTRIM(Thisform.bname.Value),LEN(bname)+1))) = (UPPER(bname)+" "));
OR (UPPER(RIGHT(ALLTRIM(Thisform.bname.Value),LEN(bname)+1))) = (" "+UPPER(bname)));
You may have to verify the parens here, I'm not sure I got them exactly right
If bname = "is" This should find
"my name is my name"
"is this my name"
"how do you know what my name is"
and ignore
"my name isn't this"
"isn't this my name"
"my name isn't your name"