upper method is available in ibatis

[supriya .pelluru]

Hi to All


i am don this query in sql first , the query is



select * from usersselections where status='N'

 and (request_status='N' OR request_status='y')


and upper(memberid)=upper(?)



now i am  changing into ibatis like this


<select id="select list of books based on status and request status"
resultMap="ReturnedBooksFormResult"     parameterMap="selectbookid">
select
*

FROM    IBATISUSERBOOK
 WHERE  STATUS='N' and (REQUEST_STATUS='N'  OR   REQUEST_STATUS='Y')

 and  upper(MEMBERID)=upper(?)


</select>


when i am creating this i got dobut at upper() method

if any on know solution for this query please reply me