| http://www.w3.org/ns/prov#value | - I want an update statement that will look at the value in the ITEMNMBR column - if it has 11 characters - add '0' (to the first space) if it has 12 characters - leave it alone.here is an example of my insert statement:INSERT INTO [RBI].[dbo].[IV10303]([STCKCNTID],[ITEMNMBR],[LOCNCODE],[BINNMBR],[UOFM],[QTYBSUOM],[COUNTEDQTY],[DECPLQTY])VALUES('OCTOBER2012' ,031568486340 ,02 ,'BINNMBR' ,'EACH' ,1 ,1
|
