Hi ,
Thanks for the reply.
I used LIKE in my select statement for getting all the names starting with a specified letter eg the user enters 's' then the select statemnt retrieves all the names starting with 's'.
I got it working i had to trim some of the variables.
Thanks.
Hi,
I have a stored procedure which doesnt work the problem comes with select statement and that too with the LIKE keyword. Any suggestion how to use LIKE keyword in a select statement in a cursor appreciated.
Thanks.
create procedure SPQTBYNAME(
IN PRMLASTNAME CHARACTER (25)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.