Claude,
In your sql statement you just need to do it something like so:
Select Hotel, City, Phone
>From YourDatabase
Where Hotel Like '%search_string%'
Order By Hotel
That where statement is the key, it would return anything with the word
Hotel in it. You can set it up to search anything. Let me know if you need
any more help on this one.
Bill
> -----Original Message-----
> From: AustralianAccommodation.com Pty. Ltd.
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 15, 1999 9:53 AM
> To: [EMAIL PROTECTED]
> Subject: searching for key words using cf
>
>
> I need to extract out of the database those records who value in the
> Property Name field contain a certain work
>
> eg Sofitel Hotel
>
> I need to find the record by searching the property name field
> for the word
> "hotel"
>
>
> Kind Regards
>
> Claude Raiola (Director)
> AustralianAccommodation.com Pty. Ltd.
> Website: www.AustralianAccommodation.com
> Email: [EMAIL PROTECTED]
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
