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
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
Comment