>>>I have a field in a table whereby users will enter the name of a supplier. A supplier name could be 'Le Poutre'. In my query I want to remove the spaces in the field. How can I do this so the result would be 'LePoutre' instead of 'Le Poutre'.
>>>
>>>Mnay Thanks in advance
>>Neil
>>
>>Try
>>
>>SELECT STRTRAN(fieldname," ","") as fieldname FROM tablename
>>
>>Nick Mason
>
>
>this might or might not work.
>if the first record contains only a 'a' for example the width of the column will be 1 even if the content of this field in the second record is 159 charcters wide!!!!
>
>Peter
Your are right. My carelessness

so how about

SELECT STRTRAN(fieldname," ","")+SPACE(nn-LEN(ALLTRIM(fieldname))) AS fieldname FROM tablebname

where nn is the length of the field


Nick