ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From HelpMePlz <supriyanaidupell...@gmail.com>
Subject like issue plz help me
Date Wed, 23 Sep 2009 12:03:43 GMT

Hi to all,

select * from Someone where name like 'a%' 
this is in oracel 

if i run this query  i am getting only 3 records 

for this query in ibatis 

Select * from someone where UPPER(NAME) LIKE  '%' ||
			UPPER(#name#)||'%'

if i run this query i am getting all the results which  name contain 'a ' 
in that like i am getting 10 results but i have to get only 3 results which
name strating  with 'a'


please can any one help me it is very urgent for me 

i tried like this also which is qiven in FAQ in Ibatis 


Select * from someone where UPPER(NAME) LIKE  '%%' ||
			UPPER(#name#)||'%%'
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+LIKE+in+my+queries


'



-- 
View this message in context: http://www.nabble.com/like-issue-plz-help-me-tp25531101p25531101.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message