General information
Category:
Coding, syntax & commands
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only