I was wondering if anyone could help me with some SQL code to run an update query for a memo field I have. The memo field was imported from a dbase file and as a result I have these funny characters throughout the memo field in each record. The problem is defined in MS Knowledge base and their solution is described below:
RESOLUTION
You can create an Access Basic procedure to remove these characters from the Memo field. The procedure should go through each record in the table and copy the Memo field, character by character, to a temporary holding area, ignoring all instances of Chr(161). The procedure should then copy the corrected string back into the Memo field.
An example of my memo field is below:
11/23/2001 CAR SOLDìON 10-24-2001ìCUSTOMER TO PICK UP.ì
#40545.
The "i" character is followed by a "|" looking character that is bold (this character doesn't come through when I paste here) These two characters need striped and replaced with a space.
Before someone tells me I'm posting in the wrong group...I was wondering what the SQL solution to this problem would be. I'm still awaiting help from some of the VB forums here and so far the solutions I've gotten haven't been very simple.
RESOLUTION
You can create an Access Basic procedure to remove these characters from the Memo field. The procedure should go through each record in the table and copy the Memo field, character by character, to a temporary holding area, ignoring all instances of Chr(161). The procedure should then copy the corrected string back into the Memo field.
An example of my memo field is below:
11/23/2001 CAR SOLDìON 10-24-2001ìCUSTOMER TO PICK UP.ì
#40545.
The "i" character is followed by a "|" looking character that is bold (this character doesn't come through when I paste here) These two characters need striped and replaced with a space.
Before someone tells me I'm posting in the wrong group...I was wondering what the SQL solution to this problem would be. I'm still awaiting help from some of the VB forums here and so far the solutions I've gotten haven't been very simple.