Hi,
What is the DBMS you are using, if its SQL server, take a look
at full text indexing feature in sql server.
And next time you are posting to the group please use a more appropriate
subject line.
HTH
Chamindu
**** DISCLAIMER *****
This e-mail and any attachments thereto are intended for the sole use of
the recipient(s) named above and may contain information that is
confidential and/or proprietary to the hSenid Software International
(Pvt.) Ltd. Any use of the information contained herein (including, but
not limited to, total or partial reproduction, communication, or
dissemination in any form) by persons other than the intended
recipient(s) is prohibited. If you have received this e-mail in error,
please notify the sender immediately and delete it.
-----Original Message-----
From: Melvin Ocampo [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 1:13 PM
To: [EMAIL PROTECTED]
Subject: Re: Re: [ASP] OT: FTP Security
Hello group,
does anybody has an idea how can I create some sort of word search,
user will supply word or sets of words on text box then after hitting
search button it will search on the save texts on the source database
then display
the result on the window, I had a hard time treating each words as
different search strings
example : text box= my apple juice
SQL ==> select description from table.description where description
like 'my%' or
description like 'apple%' or description like 'juice%'
*sample SQL only to display the logic or the flow
thanks a lot
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
