Hi,

u r telling that in the 3 peices, only first two pieces is the PK. so cut the whole 12 chars to two pieces.

1. char(3 + 6) Piece1, primary key

2....

Dear Newbie,

When there is no enough disk space in the Hard disk, The database will be suspected. U won't loose any data nor the DB is corrupted. No body can...

see the convert() in BOL.

Venkata Srinivasa Rao

select distinct proc_id

from <table1>

where proc_profile_id <> 13

in the case of performance issue ... its preferrable.

fine.

Venkata Srinivasa Rao