I tried searching the mailing list for "where...like" entries but couldn't find any.
I am using sqlMaps 2.1.7.
I am trying to run this [snippet] statement:
and upper(c.first_nm) like #firstName#
I have created the firstName variable ala' [simplified]:
String firstName = new String("S%");
and placed it into a Map under "firstName".
There has yet to be a functional index created on Oracle for the c.first_nm.
I don't return any records -- is there anything obvious I am doing wrong? Can someone give me some "like" examples?