You could use the CONTAINS operator I think instead of the equal operator.
Arden Weiss
410-757-3487
-----Original Message-----
From: David Shadovitz [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 3:28 PM
To: CF-Talk
Subject: OT: MS Access query
I'm trying to write an MS Access query like this:
SELECT Table1.Title
FROM Table1, Table2
WHERE Table1.Title = Table2.Title
The problem is that the Title fields' values may not be exactly equal.
Table2.Title may have additional text in parentheses at the end. For
example:
Table1.Title = "The cow jumped over the moon"
Table2.Title = "The cow jumped over the moon (really)"
I thought of using the LIKE operator, but it appears that LIKE only works
when comparing a field and a string, not two fields. If I'm wrong, please
tell me the syntax.
Any other suggestions on how to do this query?
Thanks.
-David
------------------------------------------------------------------------
------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
https://secure.houseoffusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
