I'm confused with wildcards in why I'm getting results in SP's with * and not % when it's the other way around in CFQUERY - esp dealing with JET databases
* is the wildcard operator for the Jet database engine
You can use % in CFQUERY if you are using an ODBC connection to the database because the ODBC connection will use the Jet OLE-DB Provider, which allows % to be used in place of *
Mark
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
