What does <> mean?

Question

I have seen this before in SQL and VB, I am now reverse engineering an Excel speadsheet and have come across the following formula:

=IF(D23<>0,"Insufficent",0)

I am converting it to ActionScript:


var result:String = [condition] ? 0 : "Insufficient";

but I am unsure of what D23 <> 0 means, is it simply "not equal"?

I think the <> inequality operator actually originates from the BASIC language. — Tamas Czinege, Feb 10 '09 at 14:14
I instinctively read it as "different from". "!=" hits me milliseconds after. — kalyanji, Feb 10 '09 at 14:30

Binary Worrier · Accepted Answer · 2014-11-03T11:47:33.037

75

Yes, it means "not equal", either less than or greater than. e.g

If x <> y Then

can be read as

if x is less than y or x is greater than y then

The logical outcome being "If x is anything except equal to y"

edited Nov 03 '14 at 11:47

answered Feb 10 '09 at 14:01

Binary Worrier

okay!! First I was confused with the question! I knew about "not equalto" but was wondering if there is anything else :) – Shoban Feb 10 '09 at 18:28
1

This made me think, what's the oprator for "equal"? Is it just "="? – Shayan Oct 30 '20 at 15:13
1

@Shayan: In vba, yes "=" means "equal" for simple types `if i = 1 then`. For objects you need is `if objRefA is objRefB then`. [See this question for more](https://stackoverflow.com/questions/11254401/vba-how-to-test-for-object-equality-whether-two-variables-reference-the-same-o/11254505) – Binary Worrier Sep 21 '21 at 14:13

score 10 · Answer 2 · answered Feb 10 '09 at 14:12

10

Yes in SQl <> is the same as != which is not equal.....excepts for NULLS of course, in that case you need to use IS NULL or IS NOT NULL

answered Feb 10 '09 at 14:12

SQLMenace

score 7 · Answer 3 · answered Feb 10 '09 at 14:01

7

It means not equal to. The same as != seen in C style languages, as well as actionscript.

answered Feb 10 '09 at 14:01

Kibbee

score 4 · Answer 4 · answered Feb 10 '09 at 14:00

4

Yes, it's "not equal".

answered Feb 10 '09 at 14:00

Jacob Mattison

score 4 · Answer 5 · answered Feb 10 '09 at 14:33

4

"Does not equal"

answered Feb 10 '09 at 14:33

Joshua Fox

5 Answers5