This field is usually either empty, or contains more than 5 characters. If it has any data in it, I want to have a single trailing space at the end (a full stop and then space actually, but the "." is the easy bit).
The reason is that I am using this to power a mail merge in word, and two fields of the table are printed next to one another, effectively forming two sentences in a single paragraph.
From the mail merge side I can supress any blank records (most of them), but where there is data, I want a space before moving to the new sentence.
...and just to pre-empt - a leading space in the second field doesn't work, since this puts a space in, even if the first field is empty and thus not printed.
Jonathan Challis
IT Manager