How do I locate the position of character in a string in Access?
Posted on 2011-02-15
I have a string in a field: "MS Steven, Middletown, Chicago, US"
How do I detect the position of last occuring ","? <--that one behind Chicago?
I know Instr function, but how do i detect in a reverse order?