I need to create a procedure which checks to see if a record exists in sql server and if it does, return some parameter so I can do further processing in VB.net.

Can anyone point me in the right direction ?