Re: Issue, not sure how to solve

That did the trick for that one.  I wonder how many other fields have
successfully gotten "the unprintables"??  .. .. .. and how many other
unprintable characters do I need to select on??

The joys of development.

Thanks again.

Dirk

> I have  -
> UPDATE telephone
> SET number = REPLACE(number, '\016', ''), object_version =
> object_version + 1
> WHERE number LIKE '%\016%';
>  - in my notes, which at least removes one 'bogus' character.
> 


-- 
OpenGroupware.org XML-RPC
[email protected]
http://mail.opengroupware.org/mailman/listinfo/xmlrpc