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 Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h3tcadq/M=362329.6886308.7839368.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1124877954/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/
