Thanks a lot, this clears up a number of things for me.
Just one more question on this:
can I get the equivalent of using == with a BETWEEN statement? as I get the same problem when using BETWEEN, preferably without SET ANSI ON as it may affect older code.
TIA, Craig.
- Craig
"If you're not prepared to be wrong, you will never come up with anything original."
- Sir Ken Robinson