>I have a table that uses pessimistic table buffering (and is filtered). Before the user saves the data, I want to check for certain things like duplicate address, etc. I use a Select statment to do this:

Cindy explained it pretty well. Take a look at IndexSeek() if you still need to check for duplicate records.