I want to do the following select
Code:
select   sure_name, english_name from student2 where  sure_name like
'test%'
union all
select   sure_name, english_name from student2 where  english_name like
'test%'
is an other way to handle it?
Thank you