Hi,

does anyone know how to convert decimal numbers to octal using a comand in a query , for intance in excel the command is DEC2OCT(val)

Cheers

A quick google turns up this page
http://msdn2.microsoft.com/en-us/library/aa139962(office.10).aspx

Good luck !

super , just type oct(val) , thanks alot for the tip ... very uselful web page