Re: Any Ideas?

Matt, this is not a direct answer to your question, more a tip on how you design your database: You should avoid storing the same information twice. You only risk inconsistencies. In your case I suggest you compute the textual ID from the primary key value using the PHP sprintf function whenever you need it, e.g sprintf ( "CR %03d", $primaryKey ). sprintf is the function to use for the type of number to text conversion you are looking for. --- Geir Pedersen http://www.activio.com/