"select * from studbook1 where racecname<>'' and racecname is not null and (racecname like'%"& name &"%' or racename like '%"&name&"%' or raceno like'%"&name&"%') order by raceno "
select from table where isnull(racecname,'')<>''
select * from studbook1 where racecname<>"" and (racecname like'%"& name &"%' or racename like'%"&name&"%' or raceno like'%"&name&"%') order by raceno "
select from table where racecname is not null
select * from studbook1 where racecname <> "" and racecname is not null and (racecname like '%"& name &"%' or racename like '%"&name&"%' or raceno like '%"&name&"%') order by raceno
(racecname like'%"& name &"%' or racename like'%"&name&"%' or raceno like'%"&name&"%') order by raceno "
where racecname <> "" and racecname is not null
and (racecname like '%"& name &"%'
or racename like '%"&name&"%'
or raceno like '%"&name&"%')
order by raceno