In SQL Server, I wrote a function to parse name. For example, if passed : "Jimmy J Jones III"...it parses firstname , middle name, last name and title. Used Reverse, Charindex (built in SQL Server functions)...
I have to do the same in AS400. I found this:
But I dont think AS400 has "Reverse"...anyone has a function to parse name? Or an idea on how to go about doing that in AS400.