How to return Yes or No in SQL without if/case flows

Apart from the IFs and the CASEs from SQL, is there another way to return a table of "Yes"/"No" (in SQL)?