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