They are the same thing, both opeartors test for inequality. :)
SELECT *
FROM Somplace
WHERE ThisField <> 10
SELECT *
FROM Somplace
WHERE ThisField != 10
Are the same thing.. :)
Just use the '<>' opeartor to be on the safe side.
Jeremy Allen
[EMAIL PROTECTED]
-----Original Message-----
From: Tim Bahlke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 9:41 AM
To: [EMAIL PROTECTED]
Subject: (OT)SQL Operator <>
Hey all ...
I have been going through the SQL 7 CBT and just finished operators. With
regards to comparison operators ... != 'is not equal to', and <> 'is not
equal too'.
I do not understand <> 'not equal too'.
Can someone please explain this to me in more detail and possible provide an
example?
Thanks
----------------------------
Tim Bahlke, CIFO
Graphica
p. 230-0570
f. 230-0083
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
