Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Better Way around the barn
harvey.jim_at_gmail.com wrote:
> 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
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Wed Jul 06 2005 - 12:02:03 CDT