I love this forum, since I now uses it. You are helping me solving some isues.

Chris, your note I will look in a few days

Thnx Gail,

The field ordernr is unique, so it can't be more then one value.

I changed

update orkrg set refer1 = 'XX' where ordernr = @ordernr

in:

update orkrg set refer1 = 'XX' where ltrim(rtrim(ordernr)) = @ordernr

And now it works, anyway thanks for your comments.

Henk-Jan