Thanks you for your time but I am out of here. Have a great weekend.

CREATE TABLE [procure_det] (

 [resource_no] [rsc_dt] NOT NULL ,

 [source_code] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [source_cntl] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [abc_code] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [restrict_code] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS...

update procure_det set

vendor_no = 'GINALEVAN',

remit_to = '1',

buy_from = '1',

gtc_code = '1'

where vendor_no is NULL and source_code = 'A'

exec sp_helpindex 'procure_det'

Results: Server: Msg 21359, Level 16, State 1, Procedure...

Here are my results. Procure_det is a table.

id1_procure_det_resource_no

clustered, unique located on PRIMARY resource_no id2_procure_det_source_code

nonclustered located on PRIMARY source_code id3_procure_det_commodity

nonclustered located on PRIMARY commodity id4_procure_det_product_class

nonclustered located on PRIMARY product_class id5_procure_det_planner

nonclustered located on PRIMARY planner 

No. That did not work. I don't where or how to look for a primary key.

update procure_det set vendor_no = 'GINALEVAN' where vendor_no is NULL and source_code = 'A'

There are three other fields that need to have data. remit_to = '1' buy_from = '1' gtc_code...

I found out that there are 2 other fields that need to be filled in when you enter info in the other. I also know that Update statements can only...

That's it. Thanks!

That worked for me as well. NICE

That was it. Thanks.