hey all.
I'm stumped. Help please.

Asssume a set of files (a very large set) that have numerous possible locations that are enumerated: 1=folder, 2=soft copy, 3=different office, 4 = etc

This issue is only concerned with types 1 and 2
The file can exist in more than one location, i.e. in a folder and in soft copy
The folders are also numbered and hold multiple files.

The data table has fields: ID Name Locations

Because there are unlimited numbers of locations for a file, I've used this format for the locations field:
;2; 'this would be only in soft copy
;1,20; ' this would be a file that is only in a folder (folder # 20 in this case)
;1,20;2; ' this would be a file located in folder 20 and in soft copy

OK, the problem.
I need to find all the folders (like #20) wherein all the files in the folder also exist in soft copy:

select * from tblFiles where [every record having locations like '%,FOLDERNUMBER;%' and locations like '%;2;%']

I can't think of any way to do it.
Maybe I need to rewrite the locations system, but there is an indefinite number of location types, and only location type 1 has a sublocatoin number.

Anybody?
Thanks