468,316 Members | 2,155 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

Convert ntext to nvarchar... or use LEFT AND SUBSTRING in a ntext field

Hi, I'm pretty new to using SQL as a long standing Access users all these field types are a bit much... I have a ntext field that I need to convert to a nvarchar. I have tried cast and convert and as I understand a text field is just too big to go into a varchar (Elephant into a mini was the analagy used)

The back ground is; I have been provided a database that has a text field for address information. This field has multiple lines of address information which includes line feeds CHAR(10). I need to replace the line feeds with ", " as an application we are using sees a line feed and crashes.
I was able to do this simply in a similar version of the data by using a combination of LEFT() and SUBSTRING() but the field type was varchar.

I'm sure there is a simple solutoin to this but as a noob I'm struggling.

Any help would me most appreciated.

Cheers
Nov 4 '08 #1
1 6380
All sorted now, no need to reply.
Cheers,
Lee
Nov 4 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

19 posts views Thread by Lauren Quantrell | last post: by
1 post views Thread by Derek Erb | last post: by
3 posts views Thread by =?Utf-8?B?ZGF2aWQ=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.