Selecting Tables That Meet Certain Condition

Hi there,

I have the following script that selects tables from my database with the same column name and then I delete data that falls within a specified condition. However what I need to be able to do is just select these tables that meet the condition and then just delete the data because at the moment it's also returning tables that I don't need.

So I just want to use a cursor on a table list that meet the criteria:

1) have qid column name
2) qid >= 5000000 and qid < 1500000000 '


Example

declare @strqry varchar(1000)

declare dailyYear cursor
for SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE 'qid' = COLUMN_NAME order by table_name asc
open dailyYear
fetch next from dailyYear into @DelTable

while @@FETCH_STATUS = 0

begin

Set @strqry = 'Delete from '+@DelTable+' where qid >= 5000000 and qid < 1500000000 '

exec(@strqry)

fetch next from dailyYear into @DelTable

end

close dailyYear
deallocate dailyYear

Any help would be greatly appreciated!!

Thanks

S