Hi guys!
I'm quite confused on how EJB-QL function LOCATE works.
Correct me if I'm wrong but doesn't it works like String.indexOf()?
It returns the specified position where the search
string is located in the searched string.
Does it return a negative value when the search string is not found?
I have an author field
this line
locate(bean.author, 'Lee') doesnt return a positive number
but my table contains records with fields having the value of "Stan Lee".
I'm quite confused really what should be the return value of this function.
Thanks.
