Is there a way to combine the three names using "LIKE IN"?

Hi Andi,

You can use the in clause, for example

select * from students s where s.name in ('Andi', 'Rose', 'James');

Hi Andi,

There is not, but as you get to more advanced methods (INNER JOIN) you can make statements that have the same effect. Look at this thread on stackedoverflow and go down to the answer from Adrian Staander who's answer I'm referring to losely here :-) stacked overflow

Best regards,