Does anyone have a good function/procedure/class that can build n-sized WHERE clauses? That is, I want to be able to pass it something like an array full of populated or empty fields and have it automatically add any needed " AND ". So I could do something like:

lnElements = 4
DIMENSION laFilter[lnElements]

laFilter[1] = "One"
laFilter[2] = ""
laFilter[3] = "Three"
laFilter[4] = "Four"

oSQL.Where(@laFilter)

?oSQL.WhereClause

One AND Three AND four