Sql join using text fields
I have 2 text fields in my where clause along with 2 other fields which join perfectly. When viewing the 2 text fields, they appear to match exactly even down to the upper and lower case but will not join. I've tried = and like with no luck.
-
Hi Crystal,
I've seen this in cases where there are leading or trailing spaces to the string. To check, run something like REPLACEALL([Field],' ','#') to replace all spaces with another character to see the space character better and check whether there's something at the beginning or end.
Please sign in to leave a comment.
Comments
1 comment