Good Morning -
I have a query that uses a LEFT JOIN to identify typos and errors in a field that is populated by front end users. Essentially, the query ensures that no unknowns are skewing reports.
So far, the query logic works fine, except it is not picking out the possibility of the field being keyed with a space after the data. For instance, the query identifies (where underscore=space) _BITN306 and BITN_306 but not BITN306_.
Is anyone aware of why the last example isn't being identified by the query? Also, any recommendations on how to possibly solve for this?
Thanks.