0

Hello,

I have a problem with a varchar(15) field. We export this record with a bcp command and I get an new line in the export file from the specific field. When I look at this field then I just see 12 numbers in it. When I do a len from the field then the field has 13 characters.

Is there a way to display the 13th character?? I already tried casting to nvarchar and ntext types.

regards,

Space1000

1
Contributor
1
Reply
2
Views
9 Years
Discussion Span
Last Post by space1000
0

I already found the solution. It's not a control character. It's a combination of two fields of wich one end with a space. It's just a bug in the bcp application....

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.