How to execute a select within an IF/CASE condition?

Question

would like to know how I can use a select as a true or false condition within a case or IF:

The query to return true or false is this:

SELECT * FROM Funcionario f WHERE (f.Email IS NULL OR RTRIM(f.Email)='') AND f.FuncionarioID=@funcionarioID

The condition is, if this select returns a True If False line.

Something like this:

IF (SELECT * FROM Funcionario f WHERE (f.Email IS NULL OR RTRIM(f.Email)='') AND f.FuncionarioID=1) THEN END

Answer 1

You have to select the boolean expression you need. The * is to pick up all columns. The SELECT ***select* the information you need, if it’s a condition, use it there.

IF (SELECT (f.Email IS NULL OR RTRIM(f.Email) = '') FROM Funcionario f WHERE f.FuncionarioID = 1) THEN END

I put in the Github for future reference.