That's strange - the JET-SQL documentation suggests the wildcard is "*", and I've always had problems using anything else - I come from a SQL Server background (DBA), so am used to using "%" which has foxed me for a while in the past. Well, if it works, then great :-) Dan
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jegatha Sent: 24 August 2005 11:19 To: [email protected] Subject: RE: [AspClassicAnyQuestionIsOk] word from data base 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] 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 Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12htfoo0p/M=362131.6882499.7825260.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1124886438/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</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/
