And I should know it but I don't...

What is the simplest way to check for the existence of a value in a database. Like I wanna know if studyIdNumber FF12033 already has been inserted. I have like 14 lines of code to do it. There has to be a better way.

Thanks