In Ms-Access it works with following code
like operator is working with following code
rs.open "select * from postpro where projecttype LIKE '%flash%' ",cn,1,2
while not rs.eof
response.write rs("username")
rs.movenext
wend
Thanks dan
Jegatha
Dan Powderhill <[EMAIL PROTECTED]> wrote:
If you're using Access :-
select * from [myTable] where [projecttype] like '*flash*';
If using SQL Server :-
select * from [myTable] where [projecttype] like '%flash%;
Dan
________________________________
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Jegatha
Sent: 24 August 2005 08:44
To: Asp
Subject: [AspClassicAnyQuestionIsOk] word from data base
i have field name as projecttype in database.
this projecttype will contain more than 5 words with commas.
like
projecttype=flash,photoshop,asp,html,php, /********it may have differnt
combinations,like this**/
now i need to display the records where the projecttype contain
flash,how to do this?
how to find a particular word ?
is there any idea?
---------------------------------
Check out Yahoo! India Rakhi Special for Rakhi shopping, contests and
lots more.
http://in.promos.yahoo.com/rakhi/index.html
[Non-text portions of this message have been removed]
SPONSORED LINKS
Programming languages
<http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Programmin
g+languages&w2=C+programming+language&w3=Computer+programming+languages&
w4=Java+programming+language&w5=C+++programming+language&w6=History+of+c
omputer+programming+language&c=6&s=198&.sig=hjFSMmldhVc3zrT5SqL9xQ>
C programming language
<http://groups.yahoo.com/gads?t=ms&k=C+programming+language&w1=Programmi
ng+languages&w2=C+programming+language&w3=Computer+programming+languages
&w4=Java+programming+language&w5=C+++programming+language&w6=History+of+
computer+programming+language&c=6&s=198&.sig=td85HQ93XfErfw7wfLZ86A>
Computer programming languages
<http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=P
rogramming+languages&w2=C+programming+language&w3=Computer+programming+l
anguages&w4=Java+programming+language&w5=C+++programming+language&w6=His
tory+of+computer+programming+language&c=6&s=198&.sig=BMtgOo7dpsC1xzn1Ygp
BPg>
Java programming language
<http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Progra
mming+languages&w2=C+programming+language&w3=Computer+programming+langua
ges&w4=Java+programming+language&w5=C+++programming+language&w6=History+
of+computer+programming+language&c=6&s=198&.sig=8IuywkhSLTtpB6_iFiJoCQ>
C programming language
<http://groups.yahoo.com/gads?t=ms&k=C+++programming+language&w1=Program
ming+languages&w2=C+programming+language&w3=Computer+programming+languag
es&w4=Java+programming+language&w5=C+++programming+language&w6=History+o
f+computer+programming+language&c=6&s=198&.sig=jpmDiGf8qD8AqZNqFwDO7w>
History of computer programming language
<http://groups.yahoo.com/gads?t=ms&k=History+of+computer+programming+lan
guage&w1=Programming+languages&w2=C+programming+language&w3=Computer+pro
gramming+languages&w4=Java+programming+language&w5=C+++programming+langu
age&w6=History+of+computer+programming+language&c=6&s=198&.sig=9slR1_vZJ
lvyOINA4iLkow>
________________________________
YAHOO! GROUPS LINKS
* Visit your group "AspClassicAnyQuestionIsOk
<http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
subscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
________________________________
[Non-text portions of this message have been removed]
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspClassicAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Check out Yahoo! India Rakhi Special for Rakhi shopping, contests and lots
more.
http://in.promos.yahoo.com/rakhi/index.html
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hecg062/M=362329.6886308.7839368.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1124885948/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</a>.</font>
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> 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/
