L.

Thanks for the replay, but I have a question

how count(*) will help check if a result came back.

I am looking for a particular record last_name (smith) within the table if there is a smith the select statement will bring the record but if not the select statement will nothing is here where I need to check if something came back or not

it seems like count(*) will tell me if there are records on a table. am I missing something

Thanks for battling