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