[kennywayne07]

SELECT * FROM movielist WHERE movielist.MoviePath LIKE "\\servername\folder\subfolder1%"

Excellent.  This works, but is picking up movies that are also in \\servername\folder\subfolder2

Is that because of the operator LIKE being used in this query?     

LIKE is needed if you don't search by an exactly value. The "MoviePath" is always the full path a media file, so you have to use LIKE to list more than one movie. The % is equal to the * in a Windows Explorer search. So if your first path is "\\SERVER\Movies\Blockbusters" and your second one is "\\SERVER\Movies\Blockbusters from India" then my query will list boths.

I don't know the real paths you want to filter, so it's a little bit difficult to say what's the correct query for you.   

sql:
SELECT * FROM movielist WHERE movielist.MoviePath LIKE "\\servername\folder\subfolder1\%"

should work. Notice the additional \ before the %.