> At first, we just disassociated the node from it's schedule and changed
> it's
> contact field to indicate it's retired status.  Very quickly we found that
> there
> was no quick/easy way to tell active clients from retired clients.

Would a command like

select node_name from nodes where contact like '%retired%'

provide an acceptable way of identifying the retired nodes?