Comparison Operators


	Comparison Operators
Osolage
5-10-2007 9:16 AM
253 views
tags:
database, sql server
Osolage says:
I don't even know why I was trying to do =<... I guess it's because I'm used to using BETWEEN more than <= >=. At any rate, this may come in handy in the future.
Add a Comment
Login to Comment. Not a member yet? Sign up
Today's Top Clips

visit the Top Clips page
View the Top Clips from May 10, 2007
Embed This Clip In Your Site...
<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/2538e03b-5696-42d6-ab95-e92ddff6aba4/4C448766-FA0B-4DF4-AE6F-AE3C6DC6E5D9/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://msdn2.microsoft.com/en-us/library/ms188074.aspx" href="http://msdn2.microsoft.com/en-us/library/ms188074.aspx" style="font-size: 11px;">msdn2.microsoft.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><TH>Operator
          </TH></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><TH>Meaning
          </TH></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P> <A href="http://msdn2.microsoft.com/en-us/library/ms175118.aspx">= (Equals)</A> </P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P>Equal to</P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P> <A href="http://msdn2.microsoft.com/en-us/library/ms178590.aspx">&gt; (Greater Than)</A> </P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P>Greater than</P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P> <A href="http://msdn2.microsoft.com/en-us/library/ms179873.aspx">&lt; (Less Than)</A> </P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P>Less than</P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P> <A href="http://msdn2.microsoft.com/en-us/library/ms181567.aspx">&gt;= (Greater Than or Equal To)</A> </P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P>Greater than or equal to</P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P> <A href="http://msdn2.microsoft.com/en-us/library/ms174978.aspx">&lt;= (Less Than or Equal To)</A> </P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P>Less than or equal to</P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P> <A href="http://msdn2.microsoft.com/en-us/library/ms176020.aspx">&lt;&gt; (Not Equal To)</A> </P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P>Not equal to</P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P> <A href="http://msdn2.microsoft.com/en-us/library/ms190296.aspx">!= (Not Equal To)</A> </P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P>Not equal to (not SQL-92 standard)</P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P> <A href="http://msdn2.microsoft.com/en-us/library/ms189808.aspx">!&lt; (Not Less Than)</A> </P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P>Not less than (not SQL-92 standard)</P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P> <A href="http://msdn2.microsoft.com/en-us/library/ms184364.aspx">!&gt; (Not Greater Than)</A> </P> </TD></tr></table></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://msdn2.microsoft.com/en-us/library/ms188074.aspx"><table background="undefined" bgcolor=""><tr><TD> <P>Not greater than (not SQL-92 standard)</P> </TD></tr></table></blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/4C448766-FA0B-4DF4-AE6F-AE3C6DC6E5D9/blog/" title="blog or email this clip"><img src="http://content7.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>
New from the makers of Clipmarks: Amplify.com - Don't just share the news...Amplify it!
Clipmarks: Home; New Clips; Top Clips; Dashboard
Popular Topics: News; Life; Science; Technology; Entertainment
Get Started: Sign Up; Install Clipping Tool; How Clipping Works; Clip-to-Blog™; ClipSearch
Tools and Resources: FAQ; ClipWeek; Top Clippers; Top Tags; Site Map
About Clipmarks: About Us; Contact; Copyright; Privacy; EULA
Search Options

Today's Top Clips
