Problem with Logical Operators
Hello, i'm trying to do some query using Logical Operators like SQL SERVER, but in my SQL soesnt work like SQL SERVER.
When i use in SQL SERVER this query:
SELECT * FROM Parametros.dbo.niveles_accesos
WHERE (nvl_codigo & 8) = 8
it compares the column nvl_codigo with the 8, and shows me all the results that are = 8
But in MySQL if i use && always return 1 o 0, and never the number i was looking for return (in this case 8)
How do i make my query in MYSQL to get the same result that SQL SERVER?
THANKS...
Subject
Written By
Posted
Problem with Logical Operators
October 08, 2004 09:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.