>I have come across an old program or two that has the very old commands in them that format the result of say sum(number) as newnum and they actually tell the command to allow 7 numbers on the left side of the decimal and 3 on the right side of the number. I don't know what this is called so I can't find it in the help. Today I used CMONTH(settdate) to get the month of the date. It gave me the months with just the first 4 letters. Is this normal? Can I change this to show the whole name?
>
>Thanks in advance for your help
>
>Randall

Use the PADR() function. Sample:

SELECT ..., PADR(CMONTH(settdate),10) AS MONTHNAME, ... FROM ...