Re: Replacing Strings

Michel Cadot escribi�:
>> replace(column,'|',chr(10))
[...]
> But what about the leading spaces? Those disappear if I use replace
> or translate or even LPAD........
>
> ---------------------------------
>
> It is not my experience.
> Copy and paste what you did.

If it works for you, it's possible that the O.P. is outputting the result into an HTML document where, as HTML dictates, leading spaces are ignored.

-- 
-- http://alvaro.es - �lvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programaci�n web: http://bits.demogracia.com
-- Mi web de humor al ba�o Mar�a: http://www.demogracia.com
--