UPDATE INVENTDIM SET INVENTBATCHID='L-092'

WHERE INVENTDIMID='IDN-008354'

Flo & Terry,

Thank you very much for your help and suggestions. The lightbulb went off after reading both of your last posts.

The whole time I was looking...

Terry,

I'm sorry I really don't understand indexes very well. Consequently the script I inserted in my last post might as well have been in Chinese, it really doesn't mean...

The context of the script is:

USE [LMC_AX4_Production]

GO

/****** Object: Index [I_698DIMIDX] Script Date: 04/09/2009 09:15:54 ******/

CREATE UNIQUE NONCLUSTERED INDEX [I_698DIMIDX] ON [dbo].[INVENTDIM]

(

[DATAAREAID] ASC,

[CONFIGID] ASC,

[INVENTSIZEID] ASC,

[INVENTCOLORID] ASC,

[INVENTLOCATIONID]...

Flo,

Thanks for the prompt response. Unfortunately the condition exists 42 times including my problem child. I don't believe the index is tied directly to the column I'm trying...