select top 1 *, dbo.CheckSuperRentStat (colorcode) as superrentstat from Video2 where 1=1 and (star like '%%Theo Moore%%' or star2 like '%%Theo Moore%%' or star3 like '%%Theo Moore%%' or star4 like '%%Theo Moore%%' or star5 like '%%Theo Moore%%') order by id strSQL2: select count(id) as antal from Video2 where 1=1 and (star like '%%Theo Moore%%' or star2 like '%%Theo Moore%%' or star3 like '%%Theo Moore%%' or star4 like '%%Theo Moore%%' or star5 like '%%Theo Moore%%') session(sida): 1 sid: back: 0 intype2:
USVIDEO