Re: search all word begin "an*"

From: Val Mazur (group51a_at_hotmail.com)
Date: 05/26/04 

Date: Tue, 25 May 2004 21:10:07 -0400

Hi,

try to use % wildcard instead of * 

-- 
Val Mazur
Microsoft MVP
"Christine Imbeault" <imbeault.christine@qcmines.com> wrote in message 
news:uBA0j8oQEHA.3532@TK2MSFTNGP12.phx.gbl...
> hi,
>
> My table is
>
> TEST
> annie
> ange
> mercure
> anouk
> test
>
>
> i have a bd format DBF. i want to find all the word begin "an" in my 
> table.
> When i run the macro, the request find 0 record.  My request is
>
> Sub test()
>    Dim oConn As New ADODB.Connection
>    Dim orec As New ADODB.Recordset
>
>     lcConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
>               "Data Source=c:\a;" & _
>              "Extended Properties=DBASE IV;"
>     oConn.Open lcConnect
>       lcstring = "Select * From test where test like 'an*' "
>      orec.Open lcstring, oConn, 1, 2
> End Sub
>
> Thanks for help
> christine
>
>
>
>