General information
Category:
Coding, syntax & commands
>>>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
SELECT STRTRAN(fieldname," ","")+SPACE(nn-LEN(ALLTRIM(fieldname))) AS fieldname FROM tablebname
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