Using Select...like in XML!

[Ramon Misho]

Hello IBATIS Support In my XML file, I need to use a combination of  #value#,  like  and ‘%’.     For example, if I want all information about users whose first names start with a specific letter (say M),  I could write the following statement: Select * from users_table where user_first_name like ‘M%’   However,  if the letter is stored in #value# then I might consider writing the following statement (which is NOT working)             Select * from users_table where user_first_name like ‘#value#%’   My question is:  How does IBATIS handle this situation and how do I make such Select statement work?     Thanks a lot.       Ramon Misho System Analyst / Programmer Mapping Development   Teranet Inc. 655 Bay Street, Suite 600 Toronto, ON M5G 2K4   Phone 416.326.1322 ext 4150 Fax 416.314.6140 e-mail: [EMAIL PROTECTED] Website: http://www.teranet.ca/   The information in this e-mail is confidential and may be legally privileged.  It is intended solely for the addressee.  Access to this e-mail by anyone else is unauthorized.  If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.