Expression of non-boolean type

Originally Posted by JRED

Hi,

I'm trying to parse this piece of code, and get a non-boolean error, error 4145. any help is appreciated:

IF(SELECT COUNT(*) FROM EVENT)where EXISTS convert(varchar(10)order_id) is not null
RETURN
ELSE


DECLARE @ RED_ID

the error says a where condition is expected near where. I've run the select statement alone,without the if statement, and it is fine.

Thanks for any help.