I have two tables: students stu_name schols_selected
scholarships schol_name short_name schols_selected is made up of scholarships the students have selected, the field content will look like schol1:schol2:schol3 I need a select that does something like this select schol_name, short_name, stu_name, schols_selected from scholarships, students where short_name is in schols_selected I have tried: where short_name like '%' || schols_selected || '%' but i'm not sure how to include a field result in between like operators. how do I get a list of scholarships based one which student selected it where the selected result is a string of colon seperated options? thx, -wj -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql