Thanks for the response Neil.
It did in 97. I think this has changed in Access2000. I tried 'A%' via Perl
and directly both with no success.
Regards
CCJ
----- Original Message -----
From: "Neil Lunn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 17, 2001 3:25 PM
Subject: RE: Wildcards
> >-----Original Message-----
> >From: Clinton [mailto:[EMAIL PROTECTED]]
> >Sent: Friday, August 17, 2001 3:11 PM
> >To: [EMAIL PROTECTED]
> >Subject: Wildcards
> >
> >
> >My problem is if I run the query from perl I get no response -
> >the program
> >runs to completion with no errors (using strict and w).
> >
> >my $sql = "SELECT custID, ac_name, ac_address FROM tblAccount
> >WHERE ac_state
> >= 'VICTORIA' AND ac_name = 'A*' ORDER BY ac_name";
> = 'VICTORIA' AND ac_name = 'A%' ORDER BY ac_name";
>
> The Access ODBC driver uses '%' instead just like SQL Server.
>
> --Neil
>
> __________________________________________________________________________
> Please Note :
> Only the intended recipient is authorised to access or use this e-mail.
> If you are not the intended recipient, please delete this e-mail and
notify
> the sender immediately. The contents of this e-mail are the writer's
> opinion and are not necessarily endorsed by the Gunz Companies
> unless expressly stated.
>
> We use virus scanning software but exclude all liability for viruses or
> similar in any attachment.
>
>
