Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Line breaks in the field - how can I see them?
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01293940
Message ID:
01293954
Views:
13
>What happens if you SELECT that field that way:
>
>SELECT REPLACE(YourField, CHAR(13)+CHAR(10),'~~')
>       FROM YourTable
>
>Did you see any '~~' in the result?

No, I don't see them :( Looks like they were not saved correctly?

This is what I see
First line  Second line  Third line    Fifth Line
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform