!= What does this do?

[sammybee]

Hi All,

What does the != function do?

Cheers

Sam

 

[KenCunningham]

It's 'not equal to'

 

[KenCunningham]

I'm assuming this is part of a unix script? I should also clarify that this applies to comparisons between strings, rather than numbers (for which you'd use -ne).

 

[SantaMufasa]

Actually "!=" works fine in Oracle SQL, as well (for any data type comparisons):

SQL> select * from dual where 1 != 2;

D
-
X

SQL> select * from dual where sysdate != sysdate+1;

D
-
X

SQL> select * from dual where 'a' != 'b';

D
-
X

Cheers,

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 16:50 (21Jan05) UTC (aka "GMT" and "Zulu"),
@ 09:50 (21Jan05) Mountain Time

 

[KenCunningham]

Ah. Wasn't aware of that, thanks Dave.