one last thing Clive, I've put the whole thing into a SP to be read by a VB6 program, the thing is when I try to read the data it...

Just the trick, many thanks Clive

Clive, can I impose on your knowledge once more? in the line

exec('if exists (select 1 from ##my_table where [' + @column + '] = ''jim'') insert into ##field_name(field) values(''' +...

Thanks Clive, it now works, I've been looking at that code for ages and never spotted it !!

I was given the following code a while ago by Karl, but it just produces an error

create table ##field_name (field varchar(128))

--insert into temp table the row we want so that...

Thanks Steve, I thought that might be the case. I just wondered if the server itself kept tabs on what was happening. Oh well, back to the drawing board!

Thanks Jeff, I don't know why I didn't spot that myself... and thanks also to bitbucket

Thanks lads for the info, I've actually used the SQL below, the only problem is if I set the date to today, I get last week's data.

DECLARE @Now as DATETIME

SET...

That's great bitbucket, many thanks

Thanks William, I'll give that a try

Mahesh, it's just a little project for me, so I can cut and paste a web page, store it in the database and then displaying it on my own personal...

Thanks Steve, does that include tables etc?

Mahesh, I'm sure you are correct, but I would also like to able to store the html as well

many thanks for the quick reply

Sam, I'm having a go at your example, the only thing I'm not too clear on is the field types, are the INT type an ID type or just INT