HI all,
is there a DB2 Built in funcion that made a locate reverse, like a %Scanr of the Rpg.
Many thanks.
Bye
is there a DB2 Built in funcion that made a locate reverse, like a %Scanr of the Rpg.
Many thanks.
Bye
CREATE TABLE RAKELLR/TEST (FIELD1 CHAR (30 ) NOT NULL WITH DEFAULT) INSERT INTO RAKELLR/TEST VALUES 'TEST STRING HERE TEST' SELECT LOCATE_IN_STRING(FIELD1,'TEST', -1) FROM RAKELLR/TEST LOCATE_IN_STRING 18 ******** End of data ********
Comment