On a SELECT command where a WHERE is used, is there a way to check to see if there were any matches?
Ex.
SELECT filenames FROM test WHERE filenames = "Jim"
How do I check to see if "Jim" was found?
Thank you.
Jim Ray
