Andy Eastham put me on the right track for this solution. I just ran the
following and it works so please give him the credit.
I tested with 'van der Plas' and 'McNeil'
SET @tmp = 'van der Plas';
SELECT @tmp,
Reverse(
SUBSTRING_INDEX(Reverse(@tmp),' ',1)
)
as myOrder
FROM MyTable;
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
(H) 301-582-3752
(C) 240-291-0767
GOD BLESS AMERICA!
To God Be The Glory!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
