INT(0) as holdint SPACE(30) as holdtext {//} as holddate && This is fine 00000.00 as holdnum && 000.00 format that meets the length and decimals for the largest number you might get.