query not responding

[David Young]

Ok, here's the scoop. After 3 days of research, noone has been able to give me an answer ...hopefully someone here can..yay! Anyway, I've got several tables all with 350+ records. The db itself has about 15 tables. When I run this query: "select field1 from table1;" it just sits there. When I run this query: "select field1 from table1 where field1 between '1' and '37';" it will display 37 records as requested. Now if I run the second query ..."select..between '1' and '38';" it just sits there....I've been running queries on this table for about 10 months. It's only a few days ago it decided not to respond to me, forcing me to take down a tool that was running off the table. Any ideas or suggestions as to a query I've run hundreds of times decided to just sit there? Any help would be great! Thanks! Dave Young Applications Engineer www.gluepoint.com "We make billing easy."