Dynamic 'LIKE' Statement in SQL (Oracle)

K

knightsienna

New Member
I am trying to select from a table with the following structure :\[code\]MATERIALS idshortname longname\[/code\]all the lines where the long name is like the short name.I've tried the solution presented here : Dynamic Like Statement in SQL, but it doesn't work for me.SELECT * from MATERIALS where longname like (shortname + '%'); -- doesn't work in Oracle.
 
You must log in or register to reply here.
Top