MySQL Forums
Forum List  »  Microsoft SQL Server

Problem with Logical Operators
Posted by: Jose Osman Sansuste Tapia
Date: October 08, 2004 09:25AM

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?


Options: ReplyQuote

Written By
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.