Please, a XOR operator in T-SQL on Yukon.

[Javier Álvarez]

Please, a XOR operator in T-SQL on Yukon.

Thanks,
Javier Álvarez.
Madrid. SPAIN. Europe.

[Narayana Vyas Kondreddi]

Are you asking if there's an XOR in T-SQL? If so, yes, see "^ (Bitwise
Exclusive OR)" in SQL Server Books Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm

"Javier Álvarez" <jav...@delete.mantis-informatica.es> wrote in message
news:%23$7jdZY6D...@tk2msftngp13.phx.gbl...

[Cliff Harris]

I don't think that he's refering to a bit-wise XOR.. I think he would like a
SQL operator that is XOR... like

SELECT * FROM users
where firstname = 'Larry' XOR lastname = 'Smith'

While helpful, a bit of logic conversion can get you the same thing:

SELECT * FROM users
WHERE (firstname = 'Larry' AND lastname != 'Smith) OR (firstname != 'Larry'
AND lastname = 'Smith')

-Cliff

"Narayana Vyas Kondreddi" <answ...@hotmail.com> wrote in message
news:u1eeQSZ6...@tk2msftngp13.phx.gbl...

[Louis Davidson]

I think he means a logical operator. as in OR, AND, XOR, etc. Send to
sql...@microsoft.com, not likely to get any motion around here.

--
----------------------------------------------------------------------------
-----------
Louis Davidson (dr...@hotmail.com)
Compass Technology Management

Pro SQL Server 2000 Database Design
http://www.apress.com/book/bookDisplay.html?bID=266

Note: Please reply to the newsgroups only unless you are
interested in consulting services. All other replies will be ignored :)

"Narayana Vyas Kondreddi" <answ...@hotmail.com> wrote in message
news:u1eeQSZ6...@tk2msftngp13.phx.gbl...

[Javier Álvarez]

Yes, I refer to a SQL Operator like

SELECT * FROM users
where firstname = 'Larry' XOR lastname = 'Smith'

because is more simple and easy than

SELECT * FROM users
WHERE (firstname = 'Larry' AND lastname != 'Smith) OR (firstname != 'Larry'
AND lastname = 'Smith')

and today, all languages have a XOR Operator.

Thanks,
Javier Álvarez.
Madrid, SPAIN.

"Cliff Harris" <he...@myrealbox.com> escribió en el mensaje
news:eDzeana6...@TK2MSFTNGP10.phx.gbl...