How do you prevent spaces from being inserted into a access table when you are doing "insert into" command either throught spt or sql commmand.
For example I am trying to insert following data. The one that seems to give me problem is "A21 = 'kern61701'". I do an alltrim in sql statement (although it doesn't work with spt) and when I go and check my access database I have data as 'kern61701 ' with bunch of spaces at end. I need these spaces gone because it is used a a filename in access database. Here is my code:

A21 = 'kern61701'
.....
.....				
										
INSERT into ITCCursor (IDNumber, BadgeType, CreateDate, ChangeDate, Operator, PrintCount);
	 VALUES ((x),ALLTRIM(A21),DATE(),DATE(),"admin",0)
lnRes = TABLEUPDATE(.t.,.t.,'ITCCursor')
IF lnRes = .F. && update failed above try again directly on server table
	lcSql = "INSERT into ITCFields (IDNumber, BadgeType, "  ;
		+ " CreateDate, ChangeDate, Operator, PrintCount) " ;
		+ " VALUES (?x,?ALLTRIM(A21),DATE(),DATE(),'admin',0) " 
	lnRes = SQLEXEC(THISFORM.nCon,lcSql)
ENDIF 

Thanks
Nick Patel