hi i created stored procedure for simple table.
i need to use LIKE operator by passing argument for exampe @employeename
now i use like this
a.employee_name like @EmpName +'%'
but it is not working.can u pls tell some solution.
thanks
Printable View
hi i created stored procedure for simple table.
i need to use LIKE operator by passing argument for exampe @employeename
now i use like this
a.employee_name like @EmpName +'%'
but it is not working.can u pls tell some solution.
thanks
You saying that the query is not working as you expecting? In that case it's not related to Java, you should ask your question on a SQL forum.
Anyway, did you try to execute that query on SQL query analyzer?