select * from info
where [name] like '" & text1.text & "%'"
Another thing is that you don't want to use DataEnvironment but ADO objects
instead (ADO Tutorial
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell
"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'