> schols_seleced like '%' || short_name || '%' doesn't make sense to me
select 'Ya-Ya' from
(select
'schol1:schol2:schol3' as schols_selects
) AS X
where schols_selects like '%schol2%'
> If you look at the contents of these fields short name containts
> "schol1", schols_selects containts "schol
How about
schols_selected like '%' || short_name || '%'
> 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
2010/1/9 Wes James :
> 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 somethi
