Yes.
..., EVL(po_greetin, po_name) AS po_greetin,
..., IIF(EMPTY(po_greetin), po_name, po_greetin) AS po_greetin,
>I have a table where some of the fields are:
>
>po_name
>po_greetin
>
>I want to do a sql select that pulls all of the records in the table but where po_greetin is empty, I want it to substitute the value in po_name. Is that possible? I don't recall every seeing anything like that here on the UT and I don't see anything in Help about it.
--sb--