Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Fri, Jul 14 2006 4:04 PM	Permanent Link
calivers	Hello Is it possible to find rightmost substring in a string, e.g. Name = 'SORT_SEQ_VAB_N' POS('_' IN Name) gives me 5, but I want 13. Thanks
Mon, Jul 17 2006 8:41 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	<< Is it possible to find rightmost substring in a string, e.g. Name = 'SORT_SEQ_VAB_N' POS('_' IN Name) gives me 5, but I want 13. >> Unfortunately you have to use a custom SQL function for that. You can get more information on creating such a function here: http://www.elevatesoft.com/dbisam4d5_customizing_engine.htm under "Custom SQL and Filter Functions" -- Tim Young Elevate Software www.elevatesoft.com