multiple percent signs in single prerequisite?

[Kevin Murphy]

I have the need to use two percent signs in a single prerequisite in a static 
rule, and make 3.79 (OS X) doesn't seem to let me do it.  I would ideally 
like to loop over a bunch of names and have total textual reign in 
substituting that name wherever I want in the rule, but I'm not sure how to 
do this.   See below for an example of what I'm trying to do.

Of lesser importance (because I have a workaround), I would also like the 
command to be able to refer to prerequisites by position (i.e. refer to the 
second prerequisite), but it doesn't look like there is a direct way to do 
this.  I can't use $(word ...) because one of the prerequisites may contain 
spaces.  In general, I guess using filenames with spaces in them is asking 
for trouble.

Thanks,
Kevin

P.S.  Here's what I tried first:

DATA_DIR = /Volumes/4D\ DB\ HD/COMPdbTest/Data/export

# many tables                                                                   
                                                                           
TABLES = agp_clones \
assemblies \
bandimagemap 
                                                                                
                                                              
TARGETS = $(foreach TABLE, $(TABLES), $(TABLE)_rebuild.sh)
                                                                                
                                                              
all: $(TARGETS)
                                                                                
                                                              
# %_rebuild.sh is created by tdf_to_sql
$(TARGETS): %_rebuild.sh: %.tdf $(DATA_DIR)/%/%.export
        echo tdf_to_sql --postgres --schema=original --datafile=$^

###