>-----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.
