SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:34 PM
| ||||
| ||||
 How to edit long text data in SQL Server Hi Guys, I have editing a SQL Server table field that have long text data. I am updating some text in this field. How can I update this field instead of re-write all text. With the Select command its gives me complete text in one line and it hard to read it. Any idea. Thanks in Advance Adnan      |
|
02-28-2008, 06:34 PM
| ||||
| ||||
| Re: How to edit long text data in SQL Server haroonqureshi@sympatico.ca (Adnan Jamil) wrote in message news:<6fbfa40b.0310290829.334c8bd6@posting.google. com>... > Hi Guys, > > I have editing a SQL Server table field that have long text data. I am > updating some text in this field. How can I update this field instead > of re-write all text. With the Select command its gives me complete > text in one line and it hard to read it. Any idea. Thanks in Advance > > Adnan I don't really understand what your issue is - perhaps you can give some more information? Are you trying to replace part of a string? If so, you can use UPDATETEXT for text columns, or REPLACE() for char/varchar columns. Simon |
Linear Mode
