I just looked it up, and you are right. It is a reserved word. However, that doesn't exactly explain why "Select Type from TableName" does work, except for always returning 4 characters instead of 1. It returns the correct data from the field (one character), just padded with 3 spaces on the right.
I guess regardless of the answer to this question, I am going to have to change the name of the field. Thanks. [EMAIL PROTECTED] ("Mercea Paul") wrote : > Try this: > Select "Type" from TableName > > "Type" is reserved word as I remember. > > Regards, > Paul > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider