SQL 7.0 Database problem.

Wow... I just notice that all the SQL queries are asked here and not in SQL - structured query language forum directory.

Dumbo me.

Anyway I have a question regarding SQL.

I have my database in the office... and one of the database have about 40 tables and one of my tables have about 20,000 records only.

Some how I put this SQL statement shown below>

Select * from <TableName> where <ColumnName> like '%em1019%'

And some how there are no records shown in the result pane but after about 5 min there are results coming out and then 5 min later it goes blank and vice versa another 5 min.

Any one have face this kinda problem before?

Oh yeah I have one Table in the database that contain 400,000 records is it to big?

NHK