Thanks,
I realised that now. I didn't know how to specify the precision and scale and I couldn't find anything online or in any books here at work. I found an O'reilly asp in a nutshell book at home last night and found what I wanted to know virtually straight away. Those O'reilly nutshell books are great.

Phil.