From this am I right in thinking that as the two queries are the same they both implicitly convert to VARCHAR(5) and that the conversion process is using the ANSI_PADDING...
Thanks for your reply. My first on this board :-). Because of the number of queries possibly affected I'm hoping to avoid having to change them all. Obviously this may...