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]

Reply via email to