[snip] It may be a little more complicated then I made it out to be. I am just trying to pull out the file extension but there were some conditions I did not list. [/snip]
Thank you for that update, would have been good to have from the start. SELECT SUBSTRING_INDEX('my.doc','.',-1) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org