Ampersands (&) and SQL statements

In ORACLE SQL statements, is there a way to not dereference a variable if the user enters a & within his/her response.

SELECT * FROM table WHERE '&yoyo%'
user enters k%s

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!