Sql join using text fields

Comments

1 comment

  • Avatar
    Sam Ovenshine

    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.