write sql by ExpressionBuilder
Posted on 2006-11-21
-I wanna perform a select task in toplink (an ORM framework of oracle) using ExpressionBuilder
but i don't know how to write this sql statement in ExpressionBuilder syntax.
here is my sql syntax :
"select * from "Information" where ("LastName" || "MiddleName" || "FirstName") = 'MrJohnSmith' "
please help me how to write this
thanks so much