hi iapearsall,

I'm not sure I really understand what you are trying to do but, I'll give an answer a shot.

How many variations of the school name do you have?

If the 9 schools you mention are the number of variations, is it possible to do a quick update statement on the table in question?

For example,

UPDATE SchoolTable

SET SchoolName = "X"

WHERE SchoolName = "A" OR SchoolName = "B"... etc?

I may be thinking of this in too simple of terms.

Let me know! 🙂

~Steve