SELECT * FROM Table1 WHERE Assignment LIKE '%5%'
hth
> 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]
