We are using MobiLink to communicate. I am trying to match a username with an ml_database record. The ml_database record looks like username (app version). In order to match, I compare the username to LEFT(username, CHARINDEX('(',username)-2).

This works unless the username has parentheses. I have instances where the username might look like "Joe Smith (2)" and the remote_id might look like "Joe Smith (2) (7.1.63.219)". Then my formula will be trying to match Joe Smith (2) and Joe Smith, and will fail.

If all of our versions looked like 7.1.63.219 we wouldn't have a problem, but sometimes they look like 2.1.24.1991, so I can't search for just "(7".

The only thing I can think of doing is reversing the orders o the letters in the remote_id, so I'd get ")912.36.1.7( )2( htimS eoJ". Then I could find "(", which would be 12. Then length - 12 is the value I want. But SQL doesn't seem to have a reversing function, which means I would have to write one.

​