SELECT WHERE a AND b OR y AND Z

[emozley]

Hi,

Is it possible to make this SELECT statement any shorter? Or does SQL require that there is zero room for ambiguity?

SELECT FirstName, Surname, UserID FROM Users
WHERE FirstName ='aaa' AND Boardroom=FALSE
OR Surname LIKE 'aaa' AND Boardroom=FALSE

Ideally would want to avoid having to specify Boardroom being FALSE twice.

Thanks

Ed

 

[flyover789]

SELECT FirstName, Surname, UserID FROM Users
WHERE (FirstName ='aaa' OR Surname LIKE 'aaa') AND Boardroom=FALSE

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Database_Systems and _Applications shared across all Business_Areas[/blue]

 

[emozley]

Perfect cheers.