<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi All:<BR>
<BR>
I think the following should eliminate the doc_char records if any one has the bad gm part. I once drove an Opel, a nice car!<BR>
<BR>
acc apmisumi link ( doc-char +"632654450" + " 12844161" ) to <FONT face=Arial>APMISUMI-KEY </FONT>of apmisumi alias bad_part optional<BR>select apmisumi if source-code = "632654450" and gm-part <> " 12844161" and (flag-905="P" or flag-905="C") <BR>select if not record bad_part exists<BR>rep doc-char source-code gm-part flag-905 <BR>go<BR> <BR>
<HR id=stopSpelling>
Subject: RE: Problem in screen design<BR>Date: Mon, 15 Mar 2010 11:50:45 -0400<BR>From: Vidyasagar.Goparaju@kewill.com<BR>To: JNalder@ascprofiles.com; powerh-l@lists.sowder.com<BR><BR>
<STYLE>
.ExternalClass p.ecx1bdeda30-d0c9-4d87-90b0-c16da710a7b2, .ExternalClass li.ecx1bdeda30-d0c9-4d87-90b0-c16da710a7b2, .ExternalClass div.ecx1bdeda30-d0c9-4d87-90b0-c16da710a7b2, .ExternalClass table.ecx1bdeda30-d0c9-4d87-90b0-c16da710a7b2Table
{margin-bottom:.0001pt;}
.ExternalClass div.ecxSection1
{page:Section1;}
</STYLE>
<STYLE>
.ExternalClass .ecxshape
{;}
</STYLE>
<STYLE>
</STYLE>
<STYLE>
.ExternalClass a:link
{;}
.ExternalClass span.ecxMSOHYPERLINK
{;}
.ExternalClass a:visited
{;}
.ExternalClass span.ecxMSOHYPERLINKFOLLOWED
{;}
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal
{margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman';}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.ecxMsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass span.ecxEmailStyle17
{font-family:Calibri;color:#1F497D;}
.ExternalClass span.ecxEmailStyle18
{font-family:Arial;color:navy;}
@page Section1
{size:8.5in 11.0in;}
.ExternalClass div.ecxSection1
{page:Section1;}
</STYLE>
<DIV class=ecxSection1>
<P class=ecxMsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">This is a single file, simple query. If you say don’t select a record that has part-number = ‘x’ it should not select it…it is that simple.</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Only thing that I can think of is the gm-part field that you see on the report is different from what is in your select statement. I guess it is that white space in front of the part number.</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Thy the following:</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">acc apmisumi</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">select if source-code = "632654450" and “12844161” <> <B><FONT color=fuchsia><SPAN style="FONT-WEIGHT: bold; COLOR: fuchsia">TRUN(LJ(gm-part))</SPAN></FONT></B> and (flag-905="P" or flag-905="C")</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">rep doc-char source-code gm-part flag-905</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">go</SPAN></FONT> <BR><BR><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<DIV>
<DIV class=ecxMsoNormal style="TEXT-ALIGN: center" align=center><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=ecxMsoNormal><B><FONT face=Tahoma size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> powerh-l-bounces+vidyasagar.goparaju=kewill.com@lists.sowder.com [mailto:powerh-l-bounces+vidyasagar.goparaju=kewill.com@lists.sowder.com] <B><SPAN style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Nalder, Jay<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, March 15, 2010 10:28 AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> powerh-l@lists.sowder.com<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Problem in screen design</SPAN></FONT></P></DIV>
<P class=ecxMsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri">How about building a record complex something like this Quiz code:</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=r_ansi size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">access apmisumi link (doc-char + source-code + "12844161") to APMISUMI-KEY of apmisumi alias xpart optional</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=r_ansi size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">select if source-code of apmisumi = "632654450" and not record xpart exists</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=r_ansi size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=r_ansi size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">rep doc-char source-code gm-part flag-905 </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri">Based on the premise that you want SOURCE-CODE to be “632654450” then for each APMISUMI record found it will try to find a match using the questionable GM-PART.</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri">The select statement will only get the ones that do not match to the selected GM-PART.</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri">Can a similar structure be built in QDESIGN? Probably, I’ll leave that unanswered.</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri">Regards</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri">Jay Nalder.</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri"> </SPAN></FONT></P>
<DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=ecxMsoNormal><B><FONT face=Tahoma size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> powerh-l-bounces+jnalder=ascprofiles.com@lists.sowder.com [mailto:powerh-l-bounces+jnalder=ascprofiles.com@lists.sowder.com] <B><SPAN style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Pandurang Rajpurohit<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Saturday, March 13, 2010 1:00 AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> powerh-l@lists.sowder.com; Nisha B Pawar<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Problem in screen design</SPAN></FONT></P></DIV>
<P class=ecxMsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<P class=ecxMsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><BR></SPAN></FONT><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">All</SPAN></FONT> <BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am on screen design where a record which do not contain data passed are only be selected. Could you please help with query how can achieve.</SPAN></FONT> <BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Here is example</SPAN></FONT> <BR><BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">> acc apmisumi</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">> show item</SPAN></FONT> <BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> INPUT OUTPUT</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">APMISUMI TYPE SCALE SCALE DEC PICTURE</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> APMISUMI-KEY CHAR X(43)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">* .DOC-CHAR CHAR X(15)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> .SOURCE-CODE CHAR X(16)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> .GM-PART CHAR X(12)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> DOC-TYPE CHAR X(2)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> ORD-NUM CHAR X(13)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> CUST-ORD CHAR X(20)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> ORD-TYPE CHAR X(2)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> ORD-PART CHAR X(20)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> PART-QTY NUM 0 0 0 ^.^^^.^^^</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> WHM-QTY-ORD NUM 0 0 0 ^^^^^^^^</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> WHM-QTY-REC NUM 0 0 0 ^^^^^^^^</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> SHIP-DATE DATE YYYY/MM/DD</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> WHM-REC-DATE DATE YYYY/MM/DD</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> FLAG-905 CHAR X(1)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> PRIC-UNIT NUM 3 0 3 ^.^^^.^^^.^^...</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> VAT-CODE CHAR X(2)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> CURR-CODE CHAR X(3)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> ACT-COST-L NUM 4 0 4 ^^^.^^^.^^^,...</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> ACT-COST-F NUM 4 0 4 ^^^.^^^.^^^,...</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> AVC-COST NUM 3 0 3 ^.^^^.^^^.^^...</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> BEAF-INV CHAR X(1)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> LOC-CUST CHAR X(9)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> TOT-LINES NUM 0 0 0 ^.^^^</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> WHM-PLAN-CODE CHAR X(4)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> WHM-IN-TYPE CHAR X(4)</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> FILLER CHAR X(42)</SPAN></FONT> <BR><BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">> acc apmisumi</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">> select if source-code = "632654450" and gm-part = " 12844161"</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">> rep doc-char source-code gm-part flag-905</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">> go</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">2010/03/13 OPEL P&A DATA DICTIONARY PAGE 1</SPAN></FONT> <BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> Document number SOURCE CODE Gm Part Flag</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 905</SPAN></FONT> <BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000225071 632654450 12844161 C</SPAN></FONT> <BR><BR><BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">> acc apmisumi</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">> select if source-code = "632654450" and gm-part <> " 12844161" and (flag-905="P" or flag-905="C")</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">> rep doc-char source-code gm-part flag-905</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">> go</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">2010/03/13 OPEL P&A DATA DICTIONARY PAGE 1</SPAN></FONT> <BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> Document number SOURCE CODE Gm Part Flag</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 905</SPAN></FONT> <BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000225071 632654450 4726568 C</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000225071 632654450 5064431 C</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000225071 632654450 5325626 C</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000225071 632654450 5409420 C</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000225071 632654450 9121795 P</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000225071 632654450 12790592 C</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000225071 632654450 13219393 C</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000225071 632654450 13253738 C</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000301004 632654450 5333794 P</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000301004 632654450 11609598 P</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000301004 632654450 12762510 P</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000301004 632654450 12767670 P</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000301004 632654450 12797804 P</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 000000000302065 632654450 9270120 P</SPAN></FONT> <BR><BR><BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I need select only doc-char which does not contain part 12844161 for source code 632654450 but with this query the doc-char 000000000225071 is also selected even though it contain part 12844161</SPAN></FONT> <BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Can any one help me</SPAN></FONT> <BR><BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks & Regards<BR>Pandurang Rajpurohit,<BR>-----------------------------------------------------------------<BR>Project Manager <BR>GM - Powerhouse Tower (DDS)<BR>IBM Global Services India Pvt. Ltd. Pune<BR>Contact No : +91 020 40116372<BR>Mobile No : +91 9049009973<BR>EMAIL : pandurang.rajpurohit@in.ibm.com </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<DIV class=ecxMsoNormal style="TEXT-ALIGN: center" align=center><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=ecxMsoNormal><FONT face=Arial color=gray size=1><SPAN style="FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Arial"><BR><BR>NOTICE - This message and any attached files may contain information that is confidential, legally privileged or proprietary. It is intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error. Any dissemination, copying, use or re-transmission of this message or attachment, or the disclosure of any information therein, is strictly forbidden. BlueScope Steel Limited does not represent or guarantee that this message or attachment is free of errors, virus or interference.<BR><BR>If you have received this message in error please notify the sender immediately and delete the message. Any views expressed in this email are not necessarily the views of BlueScope Steel Limited.</SPAN></FONT></P></DIV><FONT face=Verdana color=silver size=1>
<P class=ecx1bdeda30-d0c9-4d87-90b0-c16da710a7b2><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"><FONT color=#000000><FONT color=#333333 size=1></FONT></FONT></SPAN> </P>
<P class=ecx1bdeda30-d0c9-4d87-90b0-c16da710a7b2><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: Arial"><FONT color=#000000><FONT color=#333333 size=1>IMPORTANT NOTICE: This email is intended solely for the use of the individual to whom it is addressed and may contain information that is privileged, confidential or otherwise exempt from disclosure under applicable law. If the reader of this email is not the intended recipient or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by telephone at (978) 482-2500 and return the original message to us at the listed email address. In accordance with Kewill policy, emails sent and received may be monitored. Kewill accepts no responsibility for any loss or damage should this email contain any virus, or similar destructive or mischievous code. Thank You. Copyright © 2009 by Kewill Inc.</FONT> </FONT></SPAN></P></FONT> <br /><hr />Don’t miss a beat <a href='http://go.microsoft.com/?linkid=9712961' target='_new'>Get Messenger on your phone</a></body>
</html>