Hello,
I am inserting a record into a SQL Server Remote view like below. What is happening is that the values are not trimmed when I view them in the table after the insert. Am I doing something wrong? I suppose I can have a stored procedure that just trims the fields, but I would rather see if it can be fixed at this point. TIA.

	m.GROUP_ID = GROUPS.GROUP
	m.S_GROUP = GROUPS.SUPER_GROUP
	m.GROUP_NAME = TRIM(GROUPS.NAME)
	m.PRESENTATION_SEQUENCE = GROUPS.PRESENTATION_SEQUENCE
	m.GROUP_DESC = TRIM(GROUPS.DESCRIPTION)
	m.RESTRICTION = GROUPS.RESTRICTION
	m.DROP_DOWN = TRIM(GROUPS.DROP_DOWN)
	m.RULE_TYPE = TRIM(GROUPS.RULE_TYPE)
	m.GROUP_N_OR_DESC = TRIM(GROUPS.USE_GROUP_NAME_OR_DESC)
	m.STANDARD_OPT = TRIM(GROUPS.PRESENT_STANDARD_OPT)

	INSERT INTO REMOTE_VIEW FROM memvar
	TABLEUPDATE(.T., .T., REMOTE_VIEW)