I like to validate on client because you save a round trip to server. Also, VFP is more flexible that T-SQL in this regard especially if your working row-by-row. The disadvantage of validating on client is you have to re-compile when validation rules change.

Charlie