my pk in the specific table will be id,code

and will never be updated.so i will not search by description

but by code.

I know that this is not the best solution...

HELLO,

suppose that i have the following table structure

CREAT

create TABLE [dbo].[TEST] (

 [ID]    [int]  NOT NULL ,

   [varchar] (25),

 [DESCR] [varchar] (255) COLLATE Greek_CI_AS NULL ,

 [COMID] [int] NOT NULL ) ON [PRIMARY]

GO

then when...