Hello,
I am converting an app from one DB platform to Oracle, and my previous SQL syntax contained "starts with" code. eg,
select * from employees where name starts with 'ry';
From this webpage (http://www.techonthenet.com/sql/like.php) I understand to do this in Oracle it is like this:
select * from employees where name like 'ry%';
However, there are situations where I use starts with on an inner join, where I need the match to be on a table column instead of a string literal.
For example:
select *
from user usr
inner join salesperson sp on usr.salesperson_code starts with sp.salesperson_code;
I know this seems peculiar (ie, why don't I just use equals?), but this is because the DB is setup so that users can have multiple salesperson entries for different sales operations.
So how would I tackle this in Oracle?
Thank you in advance for your help.