> thanks for your advice and warning regarding the use of the like command
if your wildcard is on the right of the search phrase ('something%')
& that column is part of an index, then your db ought to make use
of the index (at least in sql server).
> so if the like facility has problems as you suggested what do you suggest
to
> be the alternative conditional code for the query.
two choices: verity or when you move to sql server, its full text indexing.
if your intent is to search the text & then grab rows for details, full text
indexing in sql server is quite a bit faster than verity. its also 2-3 times
faster than LIKEs.
------------------------------------------------------------------------------
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.
