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