|
Home > Archive > ASE Database forum > April 2005 > carriage return
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hi,
Can any help me on how to deal with carriage return in
Sybase text column? I've been trying to catch them using
substring and I just can't. Can I refer to a carriage
return in a Select statement?
Thanks. I appreciate any help
Eric
| |
| Carl Kayser 2005-04-26, 1:24 pm |
| I'm not sure as to exactly what you mean ("deal with", "catch", "refer"). A
carriage return is a char (13) so you can do
select Text = str_replace (text, char (13), ' ') from syscomments ....
and so forth.
<teric> wrote in message news:426e7bf2.26ce.1681692777@sybase.com...
> Hi,
>
> Can any help me on how to deal with carriage return in
> Sybase text column? I've been trying to catch them using
> substring and I just can't. Can I refer to a carriage
> return in a Select statement?
>
> Thanks. I appreciate any help
>
>
> Eric
| |
|
| I can't use str_replace on other table. It's only on this
sys table that I can this str_replace function
> I'm not sure as to exactly what you mean ("deal with",
> "catch", "refer"). A carriage return is a char (13) so
> you can do
>
> select Text = str_replace (text, char (13), ' ') from
> syscomments ....
>
> and so forth.
>
> <teric> wrote in message
>
>
|
|
|
|
|