-----Original Message-----
From: Cutter
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?

use like


oracle:


select * from table where upper(field) like '%BEACH%'


the upper function and wildcards may vary from db to db.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to