G
Guest
I have created a simple sql statement that displays a couple of columns from
the first table based one column being equal in both linked excel tables and
another column not equal. It is the not equal that does not seem to work and
it looks like there is trailing space in this column but only in some of the
records.
How can I with the SQL statement remove (trim) the trailing space?
SELECT Weekly_Lab_Data_inbound.NG_Identifier,
Weekly_Lab_Data_inbound.ApplicationName
FROM Weekly_Lab_Data_inbound INNER JOIN weekly_lab_data_outbound ON
Weekly_Lab_Data_inbound.NG_Identifier = weekly_lab_data_outbound.NG_Identifier
where Weekly_Lab_Data_inbound.NG_Identifier =
weekly_lab_data_outbound.NG_Identifier
and Weekly_Lab_Data_inbound.ApplicationName <>
weekly_lab_data_outbound.ApplicationName;
the first table based one column being equal in both linked excel tables and
another column not equal. It is the not equal that does not seem to work and
it looks like there is trailing space in this column but only in some of the
records.
How can I with the SQL statement remove (trim) the trailing space?
SELECT Weekly_Lab_Data_inbound.NG_Identifier,
Weekly_Lab_Data_inbound.ApplicationName
FROM Weekly_Lab_Data_inbound INNER JOIN weekly_lab_data_outbound ON
Weekly_Lab_Data_inbound.NG_Identifier = weekly_lab_data_outbound.NG_Identifier
where Weekly_Lab_Data_inbound.NG_Identifier =
weekly_lab_data_outbound.NG_Identifier
and Weekly_Lab_Data_inbound.ApplicationName <>
weekly_lab_data_outbound.ApplicationName;