>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