By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

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

P: 2
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.

Nov 4 '08 #1
Share this Question
Share on Google+
1 Reply

P: 2
All sorted now, no need to reply.
Nov 4 '08 #2

Post your reply

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