How do I update column in SQL by removing preceding characters in column?

I need help in updating records in my table [Fruit]. Currently, I have number – name (ie 1234 - Apple) value which I would like to replace with Apple from all the records (the number preceding is not the same).

Date       ItemNo    Fruit   
---------------------------------
01/10/10   1234      1234 - Apple
01/12/10   5546      5546 - Banana   

I want to only remove the preceding number - from the column Fruit.

Date       ItemNo    Fruit   
---------------------------------
01/10/10   1234      Apple
01/12/10   5546      Banana  

How do I do this for all rows in my table?

>Solution :

How about the following:

update t set fruit=Replace(fruit, Concat(itemno, ' - '),'')