A Alex Dec 12, 2006 #1 Hi Is there a query i can run which will remove any spaces from within a field? thanks
F fredg Dec 12, 2006 #2 Hi Is there a query i can run which will remove any spaces from within a field? thanks Click to expand... All spaces "I am a nice guy" to "Iamaniceguy" NewString:Replace([FieldName]," ","")
Hi Is there a query i can run which will remove any spaces from within a field? thanks Click to expand... All spaces "I am a nice guy" to "Iamaniceguy" NewString:Replace([FieldName]," ","")
A Alex Dec 12, 2006 #3 Thank - you are indeed A fredg said: Hi Is there a query i can run which will remove any spaces from within a field? thanks Click to expand... All spaces "I am a nice guy" to "Iamaniceguy" NewString:Replace([FieldName]," ","") Click to expand...
Thank - you are indeed A fredg said: Hi Is there a query i can run which will remove any spaces from within a field? thanks Click to expand... All spaces "I am a nice guy" to "Iamaniceguy" NewString:Replace([FieldName]," ","") Click to expand...
M Marshall Barton Dec 12, 2006 #4 Alex said: Is there a query i can run which will remove any spaces from within a field? Click to expand... Use the Replace function: If the value is not editable, just use it in a Select query: SELECT this, that, Replace(other, " ","") FROM thetable If you want to permantly change all the records in a table, use it in in an Update query: UPDATE thetable SET other = Replace(other, " ","")
Alex said: Is there a query i can run which will remove any spaces from within a field? Click to expand... Use the Replace function: If the value is not editable, just use it in a Select query: SELECT this, that, Replace(other, " ","") FROM thetable If you want to permantly change all the records in a table, use it in in an Update query: UPDATE thetable SET other = Replace(other, " ","")
