Thanks Joe,

I've tested your code in the Query Analyser and observed the subtle differences, and have adjusted my code accordingly.

Thanks to everyone.

Alan

Excellent! Thanks guys.

As always, there's more than one way of 'skinning a cat'. I'm using the code below (based on the answers above) and it works exactly how I wanted it...

Brilliant!

The answer to your question was "No". I couldn't connect to Query Analyser (directly) using my login name and password.

The reason was (and here's the er, cough-cough, embarrassing bit) the...

Thanks Kory,

I am using a DSN connection and here is my connection string

Set Conn = Server.CreateObject("ADODB.Connection")

Conn.Open "Driver={SQL SERVER};Server=Server1;UID=MyUserID;PWD=MyPassword;DATABASE=MyDBName;"

Although I'm using a DSN connection, I don't mind changing it to a...

Thanks Maurice,

I'm not at my own PC until Tuesday (2nd August) and will definitely give this a try.

It looks similar to my attempt but with a few subtle, and hopefully,...

Grrrrrrr - it's me again. After I entered the above alterations, I repeatedly pressed the refresh button and repeatedly got the results that I...

Thanks Bond007, I've replaced the Set rs = Conn.Execute(strSQL) lines with rs.Open strSQL, conn, adOpenStatic and it appears to working fine. Now for...

Remi,

I'm looking into CHARINDEX now.

Alan

Can this SUBSTRING function be used within a SELECT statement? And if so, would you mind supplying an example piece of code?

The table name is BookDetails

The column name is BIC

The...

Thanks Remi, you're right, it's another slick piece of code and another one which I'll keep in my useful code folder. I've got something coming up in the next couple...

Why's that then? I've got the table working exactly how I want it.

A rolling 30 day record of activity gets registered; the oldest one gets replaced with the second...

Thanks Ray, that's what I was after.

Thanks for that extra piece about getting the results from a stored procedure Remi. I've cut & pasted that to my Useful Code document.

Just a p.s. for the above code,...

Problem has been solved. It was to do with the way that I set up the rs variable.

Here's the code that works and I hope that it may help...

You're right, it is a bit confusing. There seems to be a lot of presets going on here especially with the MyParam bits. Do I really need to do the...