ADO and Access: Obtaining substring from end of string based on delimiter
Posted on 2006-05-01
Using an ADO SQL query against MS Access, how do you obtain a varchar substring from the end of a varchar field based on a delimiter?
I have searched for an answer in a number of ways, trying to find alternates for the InStrRev, Reverse and StrReverse methods (all of which are unsupported by Access via ADO), but I have not been able to find a previously documented direct answer to this question.
Please note again, for an acceptable answer, this must be performed in a SELECT statement via ADO against Microsoft Access. I can not use VBA or VB code for this solution (if that was all I needed, I would not be posting this).
- Visual Basic 6.0 SP6
- MS ADO 2.7
- MS Access 2000 (and newer)
Thanks for any experienced insight on this delima.