Try converting it to a string literal in the final result:
'... where ' || y.name || ' LIKE ''' || y.name1 || '%'';';
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2008 Indexes