Data cleaning of values with a blank character

[mfd777]

Any suggestions welcome:<br>
I have a text field in a table that has been imported into the database. The length is 10. In each record there is a blank space &quot;somewhere&quot; in the field. I need to take out the space e.g.<br>
<br>
Field Length Should be Length<br>
------ ------ --------- ------<br>
0000 00003 10 000000003 9<br>
000 006789 10 000006789 9<br>
<br>

 

[Lzorza]

My Friend, you can create an Update Query and insert the expresion below to remove the existing blank character from the field;<br>
<br>
iif(InStr([c1];&quot; &quot&gt;0;Mid$([c1];1;InStr([c1];&quot; &quot-1) & Mid$([c1];InStr([c1];&quot; &quot+1);[c1])<br>
<br>
Good Luck<br>
<br>