SQL & PL/SQL

Hello Everyone,

I need some help. I need to build a sql query to handle a flag field from one table. The table can have several records for the same person and for each record he can have either a Y or N in the flag field.

I am trying to, if possible, write a sql statement that will tell me that if the person has either Y or N flag in any of his records, I will say Y. If he only has N, I will say no.

I can manage this using a stored procedure but hoping that someone has already done this in sql only.

Thank you all for your help.

Randy