When I submit a form and store the posted values to a table, I notice that in character strings containing spaces, the posted value has CHR(160) instead of the standard space character of CHR(32).  Although CHR(160) is an invisible character when viewed in VFP, sometimes the table is viewed in Foxpro DOS 2.5, which shows an (odd)extended character.

 

Is there any way I can ensure that Request.form('myField') returns spaces as CHR(32), or do I have to use STRTRAN(myField,CHR(160),' ') before writing to the table? 

 

Any help would be appreciated.

 

Alan