Thanks both are working.

Thanks for the reply, to exaplain the problem use this following example and see the expected result.

Create table Test(

Col1 char(1),               

Col2 int)

Go