Function you're looking for is TYPE

? TYPE('table.lastname') && Displays C
? TYPE('(12 * 3) + 4') && Displays N
? TYPE('DATE( )') && Displays D
? TYPE('.F. OR .T.') && Displays L
? TYPE('ANSWER=42') && Displays U
? TYPE('$19.99') && Displays Y
? TYPE('nTest') && Displays N
? TYPE('cTest') && Displays C

Greg

>Is there a function to return the type of field in a table. We need to know if a field is a Character field, Numeric, etc...
>
>Thanks,
>
>Jerryt