Yes I just tried that (PADR) and that is better.

Nick

>SELECT PADR(CHRTRAN(fieldname," ",""),len(fieldname)) AS fieldname FROM tablebname
>
>>>>>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
>>
>>
>>
>>where nn is the length of the field
>>
>>
>>Nick