Better Way around the barn

Is ther a better way to do this?

//Code

UPDATE JDE_INBOUNDRIP
SET JDE_INBOUNDRIP.ITEMNUMBER = (SELECT
ltrim(JDE_INBOUNDRIP.ITEMNUMBER) FROM JDE_INBOUNDRIP WHERE JDE_INBOUNDRIP.ITEMNUMBER LIKE ' 5%')
WHERE JDE_INBOUNDRIP.ITEMNUMBER LIKE ' 5%'
//End Code

Thanks Jim Received on Wed Jul 06 2005 - 10:45:23 CDT