Hi;
 Does anyone have an SQL statement that will REPLACE delete line feeds
, carriage returns, tabs , the who nine yards
I already used the following , and it worked great for the paragraph,
but, there are a pile more of these characters I can't get at


UPDATE "DHA4-Vendor" set [Notes]= REPLACE(#13+#10 WITH ' ' in [Notes]),
[AP_NOTES]= REPLACE(#13+#10 WITH ' ' in [AP_NOTES]);

any direction would be greatly appreciated

Allan

Allan,

<< Does anyone have an SQL statement that will REPLACE delete line feeds
, carriage returns, tabs , the who nine yards
I already used the following , and it worked great for the paragraph, but,
there are a pile more of these characters I can't get at

UPDATE "DHA4-Vendor" set [Notes]= REPLACE(#13+#10 WITH ' ' in [Notes]),
[AP_NOTES]= REPLACE(#13+#10 WITH ' ' in [AP_NOTES]); >>

The only other non-printable that could be added by keyboard would be #9
(TAB).

--
Tim Young
Elevate Software
www.elevatesoft.com

thanks Tim. I'm getting some more junk that I cannot get a handle on.
I'll keep on plugging

ab

Tim Young [Elevate Software] wrote:
> Allan,
>
> << Does anyone have an SQL statement that will REPLACE delete line feeds
>  , carriage returns, tabs , the who nine yards
>  I already used the following , and it worked great for the paragraph, but,
> there are a pile more of these characters I can't get at
>
>  UPDATE "DHA4-Vendor" set [Notes]= REPLACE(#13+#10 WITH ' ' in [Notes]),
>  [AP_NOTES]= REPLACE(#13+#10 WITH ' ' in [AP_NOTES]); >>
>
> The only other non-printable that could be added by keyboard would be #9
> (TAB).
>

Allan


It won't be as fast as raw sql but why not use a custom function?

Roy Lambert