Anytime!

Don't worry about it Frank - our jokes just got "mixed up"...I was referring to Mike's comments about classy ladies downing pints in coal country (northern uk) or whereever....

Wise not to Mike!

Wildh...somehow I should've been suspicious when I saw the tantalising post header - "wine database" - on going through the responses I realize that I was the only...

Frank - no one has ever accused me of being a lady yet...

However, I am "classy" in that I can down a couple...

Getting drunk impresses the ladies ?!?! Certainly never seen that pick-up line before - a guy falling senseless at my feet...ahh - maybe that's what it is - you don't...

I would have one table that would be a "master" table - would have wineID, Region, Name, color, Year

The other table would have wineID (foreign key), datedrank, rating

Is this what...

Is your object browser window open ?! This needs to be set to "show" in the object browser show/hide menu - then you select an object from the object browser...

That's good news to end my day! Thanks for getting back.

Yes - I see that with the second example....

Dinakar - this assumes that all the IDs are sequential...if they aren't (which is usually the case in the real world) then [id] % 4 = 0 will not work...

Prasad - can't think of any other solution other than one with cursors in it...

You would probably have to use a select top 4 * from table where ID =...

Great! Thx for feedback.

Do you have an ID or indexed field that's sequentially numbered ?

what are the columns you have ?

Tom - the closest I got was using 'isnull(ntusername, 'n') in the 'not like' filter - however, since I am not on a network right now it's difficult for me...

Apologies - I completely missed the "profiler" bit....

I'm experimenting with using the isnull function with the LIKE filter - will let you know if it works!