I have uploaded a file with a query.
It uses a function that strips out characters: leading and trailing 0's, dashes "-" and slashes "/" and a spaces " "
The query should return what is NOT IN importCSM-2 comparing Reference Numbers between the two tables.
In the tables, I have one record in each:
00CTCS-88288600 (notice the leading and trailing zero's)
If I run the query, I get the error and I dont know why. I also dont know if I am using the StrippedChar function correctly. The query should not return a record as the fucntion should strip the leading and trailing zeros leaving only CTCS-882886.
Please see attached. It is pared down to only 2 tables, 1 query and 1 record in both tables.