Check if Table contains specific value

Hi Guru's,

How do i check if a table contains a specific value?

I want to check if a table contains the value that a user entered, is there any option to check the table without select query.

or

which is the best way to check the table for a specific record with respect to performance?

Regards,

Sudheer.M