Newbie lost in the syntax jungle again...

The following INSERT statement works fine if all of the columns/fields are character. However, if the LIC_NUMBR field were a Smallint or TinyInt field type, what is the syntax to make this work? Note '&mLIC_NUMBR' is a VFP memory variable.

lnResult = SQLEXEC(hConn, ;
"INSERT INTO EXPORT " + ;
"(APPL_TYPE, LK_NUMBER, LIC_NUMBR, COMPANY, " + ;
" CONG_REV ) " + ;
"VALUES ('&mAPPL_TYPE', '&mLK_NUMBER', '&mLIC_NUMBR', '&mCOMPANY', " + ;
" '&mCONG_REV')" )

Similar question -- what if it were either a "bit" field and a "datetime" field type.

Thanks in advance again...