> 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"
Something like...
SELECT PropertyID FROM Property WHERE PropertyName Like '%#Keyword#%'
Regards,
Matthew Walker
Electric Sheep Web Co.
http://www.electricsheep.co.nz/
--
Tel +64-3-374 2137
Fax +64-3-377 7930
P O Box 13-907, Armagh
Christchurch 8031
New Zealand
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
