G
Guest
I have a query which compares two text fields for an exact match (I thought).
I find that it finds differences in the text strings if there is a leading
space in the string, BUT not a trailing space in the string.
HELP! I need to know whether the text fields are an exact match or not.
Novice experience in SQL...
Here is my SQL statement:
SELECT DS.FROM, DS.[Table of Requirement Keys], DS.[Present Status]
FROM DS LEFT JOIN FS ON DS.FROM = FS.[Table of Requirement Keys]
WHERE (((FS.[Table of Requirement Keys]) Is Null));
I find that it finds differences in the text strings if there is a leading
space in the string, BUT not a trailing space in the string.
HELP! I need to know whether the text fields are an exact match or not.
Novice experience in SQL...
Here is my SQL statement:
SELECT DS.FROM, DS.[Table of Requirement Keys], DS.[Present Status]
FROM DS LEFT JOIN FS ON DS.FROM = FS.[Table of Requirement Keys]
WHERE (((FS.[Table of Requirement Keys]) Is Null));