searching within the field text

[kehar]

Hi,
I have entered names of student under field NAME in Access, the names are like;-
Mohan Chaturvedi,
Deepa Agarwal,
Mona Agarwal,
Sohan Chaturvehi
etc
With the help of VB6 and Crystal report 8.5 I want to take the Report of those student within whose name the word Agarwal exist. or say the Chaturvedi exist.

In Foxpro 2.6 this type of search is called searching embedded string.

So pl complete the following code

dim a as query
query= Select * from <query name> where <query.Name = .......................

(ehar)

[ryan_vietnow]

query=SELECT * FROM <query name>
WHERE <query.name> like '%textbox1.text%';

use the like condition then concat from where do you want the comparison from.(in this example its textbox1.text.

[kehar]

query=SELECT * FROM <query name>
WHERE <query.name> like '%textbox1.text%';

use the like condition then concat from where do you want the comparison from.(in this example its textbox1.text.

Thanks, it work fine. Apart from above pl suggest the technique to shift the long line inserted below a field to seperate each record when the text of a field is wrap up by selecting CAN GROW from format field in Crystal Report.
In short the line is not shifting down when the text grow to multiple line.

(kehar)