Yes, if I use replicate I can cope with other numbers. I did try something similar with cast but that didn't work.

Thank you.

divide your numbers, e.g. by 10,000, take the integer of the result and group by that.

I've found a small change should eliminate repeating rows:

DECLARE @TableName Varchar(100)

SET @TableName = 'ASection'

SELECT

 SC.name,

 SP.value

FROM syscolumns SC LEFT OUTER JOIN sysproperties SP ON

SP.id = SC.id

and SC.colid = SP.smallid

WHERE SC.id =...

Thanks. that does the job nicely.