|
from MSAccess
itself or via CFQUERY (to the Jet db engine)? hmmm: it should be MSAccess: where surname like
"*smith*" cfquery:
where surname like "%smith%" if it’s not working, something
else is wrong (eg, surname is not a text field, an
space, etc). does: where surname like "smith"
work (yeah, no results, but no errors either)? just a thought barry.b -----Original Message----- Trying to get the like operator to work in Access 97. If I use the standard where surname like '%smith%' it fails also where surname like '*smith *' fails. Any ideas Brian Knott MIS Analyst Group Accounting & MIS, Accounting and Tax (07)383 55977 Suncorp Pty Ltd ----------------------------------------------------------------------------------- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one
of its related entities ("Suncorp"). Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or
on 1800 689 762 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author
and does not necessarily reflect the view of Suncorp. The content, including
attachments, is a confidential communication between Suncorp and the intended
recipient. If you are not the intended recipient, any use, interference with,
disclosure or copying of this e-mail, including attachments, is unauthorised
and expressly prohibited. If you have received this e-mail in error please
contact the sender immediately and delete the e-mail and any attachments from
your system. If this e-mail constitutes a commercial message of a type that you no
longer wish to receive please reply to this e-mail by typing Unsubscribe in the
subject line. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to
[EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ |
- [cfaussie] RE: Access 97 Question Barry Beattie
- [cfaussie] RE: Access 97 Question KNOTT, Brian
