custom sql joining 2 tables on a text field

Follow

Crystal Magill

March 12, 2018 15:37

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

• 

  Andrew Block March 22, 2018 14:12

  Crystal have you tried using the TRIM() function on both fields in the where clause?

  Also could you provide the SQL statement?

  Thanks

  0

  Permalink

Please sign in to leave a comment.