Please ognore last reply of OS part. Blue Monday.

Will use the hardcoded value. Thanks for the help.

Do not want to use static values in case the OS change in the near future.

Yes, the value is 8192 (if harcoded - not good programming practice )

Yes, it do work in 2000. However, after Upgrading to SQL 2005, it will not work anymore and I want to correct all possible errors before Upgrading to SQL 2005.

I...

I used the function datalength and not len to calculate the total space used and as far as I know, this function take the 2bytes per character into account -...