<html><DIV>
<P><BR><BR></P>
<DIV></DIV>
<P>Hi,</P></DIV>
<P>I have following <SPAN style="mso-spacerun: yes"> </SPAN>table named account. <SPAN style="mso-spacerun: yes"> </SPAN>How to use SQL commands to set constraint like X value of A<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>+ <SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>X value of B > 0<SPAN style="mso-spacerun: yes"> </SPAN>in following table?</P>
<DIV></DIV>
<P class=MsoNormal style="TEXT-INDENT: 0.5in">I appreciate your great help.</P>
<DIV></DIV>
<P class=MsoNormal>--Rui.</P>
<DIV></DIV>
<P class=MsoNormal><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN></P>
<DIV></DIV>
<P class=MsoNormal><SPAN style="mso-spacerun: yes"> </SPAN>Table:<SPAN style="mso-spacerun: yes"> </SPAN>account</P>
<P class=MsoNormal>
<TABLE border=1 cellPadding=0 cellSpacing=0 style="BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse; BORDER-LEFT: medium none; BORDER-RIGHT: medium none; BORDER-TOP: medium none; MARGIN-LEFT: 0.7in; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt">
<TBODY>
<TR style="HEIGHT: 34.5pt">
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; HEIGHT: 34.5pt; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; PADDING-RIGHT: 5.4pt; PADDING-TOP: 0in; WIDTH: 99.75pt" vAlign=top width=133>
<P class=MsoNormal> NAME(:char)</P></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: medium none; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; HEIGHT: 34.5pt; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; PADDING-RIGHT: 5.4pt; PADDING-TOP: 0in; WIDTH: 99pt; mso-border-left-alt: solid windowtext .5pt" vAlign=top width=132>
<P class=MsoNormal> <SPAN style="mso-spacerun: yes"> </SPAN>X (: integer)</P></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: medium none; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; HEIGHT: 34.5pt; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; PADDING-RIGHT: 5.4pt; PADDING-TOP: 0in; WIDTH: 98.25pt; mso-border-left-alt: solid windowtext .5pt" vAlign=top width=131>
<P class=MsoNormal> <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p><o:p>...</o:p></P></TD></TR>
<TR style="HEIGHT: 28.5pt">
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: medium none; HEIGHT: 28.5pt; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; PADDING-RIGHT: 5.4pt; PADDING-TOP: 0in; WIDTH: 99.75pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width=133>
<P class=MsoNormal><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>A</P></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: medium none; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: medium none; HEIGHT: 28.5pt; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; PADDING-RIGHT: 5.4pt; PADDING-TOP: 0in; WIDTH: 99pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width=132>
<P class=MsoNormal> <SPAN style="mso-spacerun: yes"> </SPAN>20</P></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: medium none; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: medium none; HEIGHT: 28.5pt; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; PADDING-RIGHT: 5.4pt; PADDING-TOP: 0in; WIDTH: 98.25pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width=131>
<P class=MsoNormal> <o:p> </o:p><o:p>...</o:p></P></TD></TR>
<TR style="HEIGHT: 34.5pt">
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: medium none; HEIGHT: 34.5pt; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; PADDING-RIGHT: 5.4pt; PADDING-TOP: 0in; WIDTH: 99.75pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width=133>
<P class=MsoNormal> <SPAN style="mso-spacerun: yes"> </SPAN>B</P></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: medium none; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: medium none; HEIGHT: 34.5pt; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; PADDING-RIGHT: 5.4pt; PADDING-TOP: 0in; WIDTH: 99pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width=132>
<P class=MsoNormal> <SPAN style="mso-spacerun: yes"> </SPAN>10</P></TD>
<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: medium none; BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: medium none; HEIGHT: 34.5pt; PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; PADDING-RIGHT: 5.4pt; PADDING-TOP: 0in; WIDTH: 98.25pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width=131>
<P class=MsoNormal> ...</P></TD></TR></TBODY></TABLE></P>
<P class=MsoNormal> <o:p></o:p></P>
<P class=MsoNormal> </P>
<P class=MsoNormal> </P>
<P class=MsoNormal> </P>
<P class=MsoNormal> </P>
<P class=MsoNormal> </P>
<P class=MsoNormal> </P>
<P class=MsoNormal> </P>
<P class=MsoNormal> </P>
<P class=MsoNormal> </P>
<DIV></DIV>
<P class=MsoNormal style="TEXT-INDENT: 63pt"> <o:p></o:p></P>
<DIV></DIV>
<P class=MsoNormal style="TEXT-INDENT: 63pt"> <o:p></o:p></P>
<DIV></DIV>
<P class=MsoNormal style="TEXT-INDENT: 63pt"> <o:p></o:p></P>
<DIV></DIV><br clear=all><hr>Get your FREE download of MSN Explorer at <a href="http://explorer.msn.com">http://explorer.msn.com</a><br></p></html>