I am using SQL Server 2000. I have a table named Purchases and a varchar (8) column named Number. I would like to remove the prefix P00 from the Number column. For instance P0013250 should be 13250. I also have records that do not contain the prefix P00. How can I do this?