Hello Forgive my poor SQL knowledge. Im looking after an SQL 2005 machine which i inherited. I typically just need to maintain it, however, Im after getting a request to change something . I have a table which has information on discounts based on percentage. The percentage number that the calculation is done is to 4 decimal places. eg 10.4755%. I need to increase the number to 6 decimal places. I figured it was easy using this article on increasing the scale in column properties. (Right click table, select design and then go to column properties) http://msdn.microsoft.com/en-us/lib... However, the column I am looking at which has the percentage, does not have scale in column properties. I can see the figure I want to change when I look right click column and select properties but I cant see it in the design column properties view. Can someone suggest how I can figure this out, other then hire in a dba who will charge me through the nose (which is very tempting) Thanks Jonobr

I found an answer to this on another forum. (You know, sometimes you just need to walk away for a while) If the datatype is Money, the scale is set at 4 and cant be changed. http://groups.google.co.uk/group/mi...