Sql join using text fields

Follow

Crystal Magill

March 12, 2018 18:39

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.

0

• 

  Sam Ovenshine March 12, 2018 18:46

  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.

  2

  Comment actions Permalink

Please sign in to leave a comment.