I'm assuming the '1001' and '1*' are being passed by the browser.  It's
possible that the '1*' is being passed with the '*' escaped, i.e. '1%2a' where
2a is the hexadecimal ASCII value for '*'.

- Mark B.

Gary Nolan wrote:
 > Using CGI to retrieve records from an Access data base the following works:
 >
 > select name from customer where custid like '1001'
 >
 > But when we try:
 >
 > select name from customer where custid like '1*'
 >
 > It does not work. I think that CGI is looking at the * and trying to do
 > something with it. Any way around this? Is there a special character I
 > should put in front of the * so it will not get acted on?
--
[log in to unmask]
Remainder of .sig suppressed to conserve expensive California electrons...

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *