I have a query which creates me a table from another depending on a value fed into it called the 'Reference' field e.g. containing: BDF/739/2005/0 (x number of rows)

What I now want to do is update that reference from BDF/739/2005/0 to BDF/739/2005/1 so that it adds a 1 to the end or a 2 or a 3 depending what the original end number was. Is there an SQL update query which can manipulate strings like this?

Any help on this would be much appreciated