How do I correct screwy output

12 Aug 2005 2:10 AM

Karolus

I'm a SQL newbie. I created a table that's a library with a variety of text
information. When I display the content, I get the following...and at
various places the combination of letters is different...what have I done
wrong either on the input or output side?

\x0d\x0a\x09\x09\x09Doing\x09\x09\x0d\x0a\x09\x09

12 Aug 2005 2:49 AM

Uri Dimant

Karolus
Can you show us DDL+ sample data + expected result?

CREATE TABLE #Test
(
col .....
.......
)

INSERT INTO balalalalal

Show quote

"Karolus" <Karo***@discussions.microsoft.com> wrote in message
news:CEF290C6-C1D3-41B7-AC90-0A4B4F64DD90@microsoft.com...
> I'm a SQL newbie. I created a table that's a library with a variety of
> text
> information. When I display the content, I get the following...and at
> various places the combination of letters is different...what have I done
> wrong either on the input or output side?
>
> \x0d\x0a\x09\x09\x09Doing\x09\x09\x0d\x0a\x09\x09

15 Aug 2005 12:49 PM

Karolus

Thanks for your help, Uri. I went back and cleaned up the original input and
that solved the problem...I have no idea where all the garbage came from, but
it's there and I've been able to remove it. Karolus

Show quote

"Uri Dimant" wrote:

> Karolus
> Can you show us DDL+ sample data + expected result?
>
> CREATE TABLE #Test
> (
> col .....
> .......
> )
>
> INSERT INTO balalalalal
>
>
>
>
> "Karolus" <Karo***@discussions.microsoft.com> wrote in message
> news:CEF290C6-C1D3-41B7-AC90-0A4B4F64DD90@microsoft.com...
> > I'm a SQL newbie. I created a table that's a library with a variety of
> > text
> > information. When I display the content, I get the following...and at
> > various places the combination of letters is different...what have I done
> > wrong either on the input or output side?
> >
> > \x0d\x0a\x09\x09\x09Doing\x09\x09\x0d\x0a\x09\x09
>
>
>