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