Sorry I'm very new to SQL and I don't know how to do that.

If someone could split the above code I would appreciate it

I forgot to mention that the 4 separate variables will be used in my classic ASP coding.

I've also had a thought overnight, if the above coding was spilt into 2...