Is there any straight forward function to perform like searches in a string...
I did search the forum!
Please suggest
Thanks.
Like searches in a string
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 39
- Joined: Tue Dec 23, 2003 3:47 am
- Location: India
Re: Like searches in a string
Checkout the INDEX function in the help or supplied PDF.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
LOCATE, FIND and FINDSTR statements can be used in routines to search for delimited substrings.
INDEX() searches for a particular occurrence (for example the first) of a given substring.
INDEX() searches for a particular occurrence (for example the first) of a given substring.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.