from foo where
goo in (something,goo,foo)
hth
....tony
tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331
-----Original Message-----
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 20, 2003 3:47 PM
To: CF-Talk
Subject: Logical operators for <CFQUERY
CF: 5.0
DB: MS Access
I am drawing a blank. What is the correct operator/format for matching
part of a field? I have CONTAINS in the below, but that doesn't seem to
work.
<cfquery name = "Query1" dataSource = "MasterData">
SELECT *
FROM Table1
Where Assignment CONTAINS 5
</cfquery>
Thanks,
Nick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
