Tuesday, July 2, 2013

DB2 : index of character of string

To find index of a charater of string in DB2.

locate(charater to find in string,string)

Eg
locate('*','ABCD*EFGH') gives 5

No comments:

Post a Comment