How to remove NewLine characters from the data in SQL Server

select REPLACE(REPLACE(REPLACE(MyField, CHAR(10), ''), CHAR(13), ''), CHAR(9), '')  from table

Comments

Post a Comment

Popular posts from this blog

How to Fix Error- Sys.WebForms.PageRequestManagerTimeoutException - The server request timed out

To solve this problem we can increase the timeout. You can change the timeout time by adding a new property to the script manager control. This property is called AsyncPostBackTimeOut and it can help us to define the number of seconds before the request will throw a request timeout exception*. For example if you want that the timeout will take maximum 10 minutes your code should be look like this: < asp : ScriptManager ID ="ScriptManager1" runat ="server" AsyncPostBackTimeOut ="600" > </ asp : ScriptManager >       * The default value of the AsyncPostBackTimeOut property is 90 seconds.
Read more

Creating groups and summaries in Grid View

GridView has a lot of improvements over the DataGrid but it still lacks some very important features. A recurring requirement not available in the GridView is to create groups and summaries. To create summaries we can easily code the RowDataBound event. Grouping is a more complex task, and involves more coding and debugging. But when we need to combine these two features the things really start to get messy. With this in mind I have implemented the GridViewHelper, as the name suggests, a helper class to aid the creation of groups and summaries. [ Online sample ] [ Download source code ] Using the GridViewHelper Below we will see some GridViewHelper samples. First we show the grid to which the groups and summaries will be created. The sample data comes from Northwind database, with a few modifications: ShipRegion ShipName OrderId ProductName Quantity UnitPrice ItemTotal NM Old Worl...
Read more

How to get content of Ckeditor & Fckeditor using Javascript

CKEDITOR: To get content of ckeditor we will create object of ckeditor and then we will provide id of textarea that is replaced by ckeditor. Syntax: CKEDITOR.instances.textarea_id.getData();getData(); Where CKEDITOR.instances   :  gives all the instances of CKEDITOR; textarea_id   : it is ID of textarea that is containing data ; getData()       : return content of Ckeditor current instance. FCKEDITOR: To get content of Fckeditor we will create Instance of Fckeditor for textarea and then we will get data using GetHTML method. Syntax : FCKeditorAPI.GetInstance('textarea_id'). GetHTML(); Where textarea_id     :  it is ID of textarea that is containing data ; GetHTML()             :  This function returns content of textarea with id textarea_id.  
Read more