DB2 for i SQL – String Manipulation – POSSTR-LOCATE-LOCATE_IN_STRING (EN)

Last Updated on 27 August 2019 by Roberto De Pedrini Index Toggle Introduction Often, in our applications, we need to work with text strings, and DB2 SQL can come in very useful and simplify our code. In this guide we see some interesting SQL functions for string manipulation: POSSTR – Search for position within a string LOCATE and LOCATE_IN_STRING – Find the location with a few more options POSSTR – Search position in a string This function returns the starting position of a character or string within another string, for example if I look for “only” within the string “This is only an example” I expect a “9” as a result… simple I would say! …