Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Removing blanks in a field
Message
From
21/12/2004 15:14:26
Peter Cortiel
Retired
Willington, Connecticut, United States
 
 
To
21/12/2004 10:11:49
Nicholas Mason
London, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Removing blanks in a field
Miscellaneous
Thread ID:
00970912
Message ID:
00971129
Views:
29
How about:
select padr(STRTRAN(fieldname," ",""),30) AS fieldname FROM tablebname

Peter

>
>SELECT STRTRAN(fieldname," ","")+SPACE(nn-LEN(ALLTRIM(fieldname))) AS fieldname FROM tablebname
>
>where nn is the length of the field
>
>
>Nick
Peter Cortiel
Previous
Reply
Map
View

Click here to load this message in the networking platform