Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
akas
Starting Member
42 Posts |
 Posted - 2009-01-15 : 11:18:23
|
Hi Genius Gurus,i have given one select statement - Select body, list, subject, dates, items FROM messages where list = 'hint' now body is text datatype field- and items is char datatype field and right now this column is blank ...i have to find in body - if there are any items and then pull it into items column...example one body - text datatype field value is below and in that whole there may be 2 or 3 items which i have to find..in this i found one item - 06-5840 (which is in bottom red colour) that i have to pull into items colum. how can i find and how can i pull...as if there are more than one items also in different body messages...its very difficult for me to find..as there are approx 900 rows and to go in each row of body field and to find first then pull it...don't know any way...is there any way???thanks folks..i will really appreciate ur help geniuses...This is a multi-part message in MIME format. --MIMEBoundarydd8ccf4c5d8f768f6474becb7f095f6b Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit Manage Your Membership Profile[1] | Invite a Colleague to Join the H [2] | Unsubscribe[3] %%iffield Domain_ aol.com **Attention AOL 9.0 users ** Please add h@ni-n.info[4] to your address book so that you continue to receive our messages.>>%% *November 12, 2004* *** Fit for Fall: New Online Program Promotes Physical Activity in English or Spanish *** Know someone who wants to get fit for fall? A new program from NI, entitled "Physical Activity: Your Heart Your Life--A Lay Health Educator's Program" available at http://hi.nbi.nh.o/salud/pa/index.htm[4] has just gone live on the NI Web site. ---------------------------------------------------------------------- The effort is an outgrowth of the popular "Salud para su Corazon" program, an exciting comprehensive community-based heart-health promotion initiative from the National Institute. It targets Latinos living in the United States, but the information in English is also suitable for a wide audience. The project raises awareness of the risk factors and promotes lifestyle changes to reduce the chances of developing heart disease. Members of the public can now interact with Angela - a virtual lay health educator - to learn how making some simple changes in their lives can signficantly reduce their risk of heart disease. The program is at http://hi.nbi.nh.o /learning.htm.[5] Angela teaches by using interactive quizzes, offering visitors a downloadable set of stretching excercises, and even suggesting a sample walking program. She also addresses common barriers to starting a moderate physical activity program. A Spanish language version of this program is also available at http://hi.nbi.nh.o /indexsp.htm[6] For lay health educators a virtual trainer of trainers, named D Festa, will help educators learn how to personally approach members of the Latino community with the same information contained in the online program for the public. The program is at http://hi.nbi.nh.o /teaching.htm.[7] The online program includes a number of free downloadable teaching aids, such as handouts, picture cards, session outlines, and more to help educators prepare and conduct a session on the importance of physical activity to heart health. A Spanish language version of this program is also available at http://hi.nbi.nh.o /indexsp.htm. More online program modules are in the planning stages, and will be announced through the NI Health Information k. *We would greatly appreciate a *quick note* at Network@ni.c om to let us know how you use this information.* ---------------------------------------------------------------------- You are receiving this e-mail notification because you joined the Health Information Network Health, or gave permission to NI to send you e-mails. These notifications are limited to the subject areas in which you expressed interest. If you do not wish to receive additional notifications, please enter your e-mail address as it appears on messages from us, at http:// ihin.net/hp2010/hp2010/unsubscribe_form.asp. You are currently subscribed as %%emailaddr%%. Office of Prevention, Education, and Control [1] http:// ihin.net/hp2010/hp2010/default.asp [2] http://hin.nhlbi.nih.gov/joinhin/invite.asp [3] http://ihin.net/hp2010/hp2010/unsubscribe_form.asp [4] http://hi.nbi.nh.o /index.htm [5] http://hi.nbi.nh.o /learning.htm. [6] http://hi.nbi.nh.o /indexsp.htm [7] http://hi.nbi.nh.o /teaching.htm. http://hi.nbi.nh.o /indexsp.htm. --MIMEBoundarydd8ccf4c5d8f768f6474becb7f095f6b Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "hmpro6.dtd"> <HTML> <HEAD> <TITLE>NI Health Information Network eBulletin</TITLE> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <STYLE TYPE="text/css"> <!-- .boldText { font-weight: bold; } body { font-family: Arial, Helvetica, sans-serif; font-size: 10px; } td { font-size: 12px; } #articleTxt { font-size: 10px; } --> </STYLE> </HEAD> <BODY> <TABLE WIDTH="640" BORDER="0" ALIGN="CENTER" CELLPADDING="0" CELLSPACING="0"> <TBODY> <TR> <TD COLSPAN="4"><IMG ALIGN="MIDDLE" HEIGHT="69" ALT="HIN e-Bulletin" SRC=" http://hi.nbi.nh.o /HIN2.gif" WIDTH="640" BORDER="0"></TD> </TR> <TR> <TD COLSPAN="4"> <DIV ALIGN="center"><A HREF="http:// ihin.net/hp2010/hp2010/default.asp">Manage Your Membership Profile</A> | <A HREF=" http://hi.nbi.nh.o /invite.asp">Invite a Colleague to Join the HIN</A> | <A HREF="http:// ihin.net/hp2010/hp2010/unsubscribe_form.asp">Unsubscribe</A> </DIV> <BR> %%iffield Domain_ aol.com <<<p><b>*Attention AOL 9.0 users *</b> Please add <A HREF="mailto:in@ni-h.info">in@ni-h.info</A> to your address book so that you continue to receive our messages.</P> >>%%</TD> </TR> </TBODY> </TABLE> <TABLE CELLSPACING="0" CELLPADDING="1" WIDTH="640" ALIGN="center" BORDER="0"> <TBODY> <TR> <TD BGCOLOR="white" WIDTH="500"></TD> <TD BGCOLOR="#351b76" WIDTH="140"> <P ALIGN="center"><B><FONT COLOR="#ffffff">November 12, 2004 </FONT></B></P></TD> </TR> <TR BGCOLOR="#351b76"> <TD HEIGHT="1" COLSPAN="2" BGCOLOR="#351b76" WIDTH="800"> <TABLE WIDTH="640" BORDER="0" CELLPADDING="0" CELLSPACING="5" BGCOLOR="#FFFFFF" STYLE="text-align: center"> <TR> <TD STYLE="vertical-align: top"></TD> </TR> <TR> <TD STYLE="vertical-align: top" ALIGN="CENTER"> <H1 ALIGN="LEFT"> <FONT COLOR="#330066"> Fit for Fall: New Online Program Promotes Physical Activity in English or Spanish </FONT> </H1> <H4 ALIGN="LEFT"> Know someone who wants to get fit for fall? </H4> <P ALIGN="LEFT"> A new program from NHLBI, entitled "<A HREF="%%track http://hi.nbi.nh.o /index.htm%%">Physical Activity: Your Heart Your Life#151;A Lay Health Educator's Program</A>" has just gone live on the NI Web site.</P> <HR> <TABLE WIDTH="639" CELLPADDING="5" CELLSPACING="5" BGCOLOR="#FFFFFF"> <TR> <TD> <P> The effort is an outgrowth of the popular "Salud para su Corazon" program, an exciting comprehensive community-based heart-health promotion initiative from the National. It targets Latinos living in the United States, but the information in English is also suitable for a wide audience. The project raises awareness of the risk factors and promotes lifestyle changes to reduce the chances of developing heart disease.</P> <P> Members of the public can now interact with Angela - a virtual lay health educator - to learn how making some simple changes in their lives can signficantly reduce their risk of heart disease. The program is at <a href=" http://hi.nbi.nh.o /learning.htm."> http://hi.nbi.nh.o /learning.htm.</a> </P> <P> Angela teaches by using interactive quizzes, offering visitors a downloadable set of stretching excercises, and even suggesting a sample walking program. She also addresses common barriers to starting a moderate physical activity program. A Spanish language version of this program is also available at <a href=" http://hi.nbi.nh.o /indexsp.htm"> http://hi.nbi.nh.o /indexsp.htm</a> </P> <P> For lay health educators a virtual trainer of trainers, named D Festa, will help educators learn how to personally and confidently approach members of the Latino community with the same information contained in the online program for the public. The program is at <a href=" http://hi.nbi.nh.o /teaching.htm."> http://hi.nbi.nh.o /teaching.htm.</a> <p> The online program includes a number of free downloadable teaching aids, such as handouts, picture cards, session outlines, and more to help educators prepare and conduct a session on the importance of physical activity to heart health. A Spanish language version of this program is also available at <a href=" http://hi.nbi.nh.o indexsp.htm."> http://hi.nbi.nh.o /indexsp.htm.</a> <p> More online program modules are in the planning stages, and will be announced through the NI Health Network. </P> <P ALIGN="CENTER"></P> </TD> </TR> </TABLE> <DIV ALIGN="center"><A HREF="mailto:?subject=Thought this would be of interest to you...&body=Thought this newsletter would interest you. http://in.n.h.gov/joinhin/news/0904salud.htm You can subscribe for free at - http://in.n.h.gov/joinhin/join.asp"><IMG HEIGHT="33" ALT="Email icon" SRC="http://hp200.nin.net/joinhin/images/mail.gif" WIDTH="36" BORDER="0"><BR><FONT FACE="Arial" SIZE="-1"><B>Forward this newsletter to a colleague.</B></FONT></A></DIV> <DIV ALIGN="center"><BR><IMG HEIGHT="1" ALT=" " SRC="http://hp201.nin.net/joinhin/news/images/horzrule_ppl.gif" WIDTH="500" BORDER="0"></DIV> <DIV ALIGN="center"> <P CLASS="ebulletinsmalltext"><FONT COLOR="#330066"><STRONG>We would greatly appreciate a </STRONG></FONT><A HREF="mailto:NINetwork@tri.net?subject=RE: Fit for Fall: New Online Program Promotes Physical Activity in English or Spanish"><STRONG><FONT COLOR="#8080ff">quick note</FONT></STRONG></A><FONT COLOR="#330066"><STRONG> to let us know how you use this information.</STRONG></FONT></P></DIV><HR> <P ALIGN="LEFT"><FONT SIZE="-2">You are receiving this e-mail notification because you joined the Health Network, or gave permission to NI to send you e-mails. These notifications are limited to the subject areas in which you expressed interest. If you do not wish to receive additional notifications, please enter your e-mail address as it appears on messages from us, at 06-5840 <A HREF="http:// ihin.net/hp2010/hp2010/unsubscribe_form.asp">http:// ihin.net/hp2010/hp2010/unsubscribe_form.asp</A>. You are currently subscribed as %%emailaddr%%</FONT>.</P> <P ALIGN="CENTER"><FONT SIZE="-1">Office of Prevention 4A10<BR> 31 Center Drive, MSC 2480<BR> </FONT></P> </TD> </TR> <TR> <TD STYLE="vertical-align: top"></TD> </TR> </TABLE> </TD> </TR> <TR> <TD ID="articleTxt" STYLE="vertical-align: top" WIDTH="269"> </TD> </TR> <TR> </TR> </TBODY> </TABLE> %%detect_both%%</body> </HTML> --MIMEBoundarydd8ccf4c5d8f768f6474becb7f095f6b-- |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2009-01-15 : 11:27:13
|
| Not sure if Wikipedia is an approved resource for these forums, but it has helped me much in the past. Check this out - it may help.http://en.wikipedia.org/wiki/SQL_Server_Full_Text_Search |
 |
|
|
akas
Starting Member
42 Posts |
Posted - 2009-01-15 : 11:37:31
|
| thanks for reply..but i don't know what to use here..but one thing sure that in all items third char is '-'means items like:06-584001-2145kt-045an-041-01so is there any way?thanks. |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-01-15 : 13:47:23
|
| This might be of help. http://technet.microsoft.com/en-us/library/ms345119.aspx |
|
|
|
|
|
|
|
|
search in txt field and pull into new blank column