Seems like SQL 101 - I'm trying to query RM00101 (Customer Master) to return all my CustomerIDs that end with xxxx_1
I don't understand why this query doesn't work? The use of '%_1%' - returns all Customer IDs that contain a '1'. It's like SQL ignores the _ .
