Thanks Jeff, I appreciate the time you've spent on this

Jeff, many thanks again. I've adapted your code to work with my database, The only thing is unless I use it on a field that is unique the results are...

Thanks Jeff, at first glance as you've said it should be easy to change this into a SP, can I get back to you when I try this out later...

Many thanks for all your assistance. you've been a great help and I think I've lean't stuff along the way

Basically, I've made a program that lists all the databases on my server,  and when I click on a table in my list it goes away and lists all the...

I've alread tried that, but no luck

That appears to work, any idea why? thanks again for your patience

That appears to work, so what is the difference? by the way, I'm very grateful for your patience

I've not been able to get it to work at all in the QA

I am at a loss, it's not just the fact that "GO" doesn't get printed, it's that sometimes whole lines get missed of too, I've even printed off quite large...

I think the short answer to both questions is no, I used a debug.print to see if the text was there but hidden.

it's not just Go that get's missed, I tried it again on another SP and I go

CREATE PROCEDURE spDeleteReminder @sMemo as VarChar(200),@sDate as varchar (200)

AS

instead of

CREATE PROCEDURE spDeleteReminder @sMemo...

it's for editing purposes, I'd be using update on the record and as I won't know which field I'd be updating it'll be difficult keeping track of which field I'd...

thanks for pointing me in the right direction

Thanks John, that worked a treat