<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><DIV></DIV>
<DIV>The problem is not the "s." You wanted a "%" to be in the query. The corrects way to do that, as the API doc states, is with "%%". That's why it worked when you changed it.<BR> </DIV>
<P><FONT color=#ff007f size=4 face="bookman old style, new york, times, serif"><EM><STRONG>Nancy</STRONG></EM></FONT></P>
<P> </P>
<P><FONT face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</FONT></P>
<DIV><BR></DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><BR><FONT size=2 face=Tahoma>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<HR SIZE=1>
</DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Austin Einter</DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"></FONT> </DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">str = <STRONG>SELECT name, id, lft, rgt FROM resubmt_skill_ids AS node WHERE ( <A href="http://node.name/" rel=nofollow target=_blank>node.name</A> LIKE "%sip%") ORDER BY node.lft</STRONG></DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">On debugging, looks the query went as </DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><STRONG>SELECT name, id, lft, rgt FROM resubmt_skill_ids AS node WHERE ( <A href="http://node.name/" rel=nofollow target=_blank>node.name</A> LIKE "ip%") ORDER BY node.lft</STRONG></DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">Then I changed the query to </DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><STRONG>SELECT name, id, lft, rgt FROM resubmt_skill_ids AS node WHERE ( <A href="http://node.name/" rel=nofollow target=_blank>node.name</A> LIKE "<FONT color=#ff0000>%</FONT>%sip%") ORDER BY node.lft</STRONG></DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">Above query returns expected records.</DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">My question is , when a token starts with "s", we will be facing above issue.</DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">What is the best way to resolve it.</DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </DIV></DIV></div></body></html>