select * from TabloAdi where [AlanAdi] like '*ban*' or [AlanAdi] is null
kodu şöyle deneyebilirsiniz
select * from TabloAdi where [AlanAdi] like '*ban*' or [AlanAdi] is null