George;

There are a lot of things we can do with VFP that other development languages will not allow. The IIF in the Select statement of the original question got me to thinking: How would Visual Basic handle this, if it could. As we know, an IIF in VB behaves very differently than it does in VFP. For a SQL Select statement it would be a real “hit”. The SQL code would be run three times : First the left side of the equality sign, next the right side and then it would evaluate the correct answer. Can you imagine that at end of the month close out for the accounting/purchasing department at a large corporation? Just a bit of a network hit.

Tom