Select *
>From table
Where field like '%Beach%'

That allows any characters before beach and any after beach.

John

-----Original Message-----
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 12:10 PM
To: CF-Talk
Subject: How do I...

pull all records from a table with the word "Beach" in the contents of a
field?

Cutter
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to