DataEnvironment1.rsZoeken....little question about .Find

I am using this code for searching : DataEnvironment1.rsZoeken.Find "NM = '" & Zoeken.Text & " ' "

That works really good when i search on exact the same value. I was wondering if there is any methode to search on a value that is not exact the same search criteria. For example i have to search "vbforums" but i find it when i search "vbf".

Please can somone reply ASAP because i need it ASAP.
Thank you,

Matrixxx

Code:

---

DataEnvironment1.rsZoeken.Find "NM LIKE '*" & Zoeken.Text & " *' "

---

Thank you for the code. It works when the value is in the first word but when it is on the second word he can't find it. Is there maybee any thing i can do about?

Thanks,
Matrixxx

Replace * with % since you're using ADO.