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.