Search a PART of a WORD ?

[desprits]

What should I do to search a part of a word ..
Exemple, I just want to do someting when I have letter A ..

Allo --> do something
Jack --> do something
Zoro --> do noting
Luc --> do noting
Amanda --> do something

Dim namePerson as String
For i = 0 to 20
namePerson = adoName.Recordset!name
If ??? then
Msgbox "Name : " namePerson
Endif
adoName.Recordset.MoveNext
next i

Thank !

 

[DrJavaJoe]

If instr(Ucase(namePerson) , &quot;A&quot <> 0 Then

&quot;Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.&quot;

 

[DrJavaJoe]

By the way desprits welcome to Tek-Tips to get the most from these forums you should read: faq222-2244

&quot;Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.&quot;

 

[desprits]

It's working..
Merci beaucoup !