菜鸟分页问题

select top 15 cardnostart,cardnoend,cardnoaddtime,lastmodifytime,lastmodifypersion from gw_cardno_bin where id NOT IN (select top 75 id from gw_cardno_bin)

这段分页是成功的

我现在还想加一个限定条件就是模糊查询出cardnostart like %4*%

这样如何加到上面的分页查询中

select top 15 cardnostart,cardnoend,cardnoaddtime,lastmodifytime,lastmodifypersion from gw_cardno_bin where id NOT IN (select top 75 id from gw_cardno_bin) [color=red]and cardnostart like %4*%[/color]