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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 what is this symbol <>

Author  Topic 

kvishnuprasad
Starting Member

13 Posts

Posted - 2009-07-08 : 02:08:55
what is this symbol used for <>

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-07-08 : 02:12:18
NOT EQUAL


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-07-08 : 02:21:16
see comparison operators in books online
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-07-08 : 02:25:46
Just as >= means GREATER THAN or EQUAL TO, and <= means LESS THAN or EQUAL TO, the <> sign means LESS THAN OR GREATER THAN.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-07-08 : 02:32:30
quote:
Originally posted by Peso

Just as >= means GREATER THAN or EQUAL TO, and <= means LESS THAN or EQUAL TO, the <> sign means LESS THAN OR GREATER THAN.



N 56°04'39.26"
E 12°55'05.63"




Interesting. Never thought of it this way.


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

waterduck
Aged Yak Warrior

982 Posts

Posted - 2009-07-08 : 03:25:16
quote:
the <> sign means LESS THAN OR GREATER THAN.

wow...i almost thought<> = NOT

AMITOFO+AMEN+YA ALLAH Hope the query works
Go to Top of Page

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-08 : 03:32:35
<> (Not Equal To) Not equal to

!= (Not Equal To) Not equal to (not ISO standard)

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-07-08 : 04:13:07
quote:
Originally posted by khtan

quote:
Originally posted by Peso

Just as >= means GREATER THAN or EQUAL TO, and <= means LESS THAN or EQUAL TO, the <> sign means LESS THAN OR GREATER THAN.



N 56°04'39.26"
E 12°55'05.63"




Interesting. Never thought of it this way.


KH
[spoiler]Time is always against us[/spoiler]




If you ask me, I would also reply the same as what Peso specified

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -