>>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