.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to remove spaces from varchar column

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

Hello guyz;

I got a varchar column that I want to remove extra spaces from its contents.

what I want to do is keeping only 1 space between each 2 words ...I don`t want to keep more than one space between each 2 words

View Complete Post

More Related Resource Links

Search - How to remove a meta tag ... / custom column is not showing up in Crawled Properties after

Hi I got the following warning after I crawled a site. Info out of Crawl Log: "The content for this address was excluded by the crawler because this item was marked with a no-index meta-tag. To index this item, remove the meta-tag and recrawl." Sound easy but I don't no where I could do it. The other problem is that I try to get a custom column from a custom list showing up in the crawle properties. I am using also a custom scope with the behavior "INCLUDE" ... In MOSS 2007 it was a lot simpler ;-) Thanks Regards MIA    

remove pattern from string as seperate column

Hey  Everyone This seems like it shouldn't be too difficult but I'm strapped for time- I have a column where the data looks like CN=kmcde,OU=People,DC=ad,DC=FLA,DC=edu I want to pull out the 'kmcde' as a new column. I'm thinking some combination of substring and perhaps patindex but can't get it to work correctly Thanks kam

How do I remove column headers in list view webpart?

I'd like to remove the column headers from a list view web part, as well as from a document library web part. How can I accomplish this in SharePoint 2010?

How to remove the blank spaces between subreports in sql server reporting service?


In Sql server reporting service the blank spaces or white spaces are coming in between the subreports, when we place the subreports in the main reports.

If any one know how to remove the blank spaces between the subreports, please reply me. Its very urgent.

How to remove blank spaces between the subreports

How to remove blank spaces between the subreports if subreports don't have data to show up?
for example if in my reports there are 7 subreports. if subreports 2 and 4 don't have any data then there is blank space between 1 and 3 and 3 and 5.

SQL Server 2008 multiple lines in a varchar(MAX) column?



I'm using varchar(Max) to store a text file content. It's not taking the newline character. I tried \n and char(13) etc.. whatever solution posted in the net.

ex : update test set f='This is line 1.' + CHAR(13) + CHAR(10) + 'This is line 2.' 

after updating it doesn't have any newline or linebreak. Can anyone help me in this how to have linebreaks in the varchar(max) field.

Thanks a lot.

best way to remove (or hide) a gridview column in a custom page


can someone tell what the best way to remove (or hide) a gridview column is within a custom page?

I dont want to show the link column that is automatically generated as a result of the relationship between the table in question and a parent table.



Using Cast and Sum on VarChar Column


Okay, so I have a little problem developing a SQL Select Statement on a column that is formatted pretty badly. Firstly, the Database has already been created and filled with Data in a Test Environment, I'm not sure if the format is the same or has been updated in Production but since I'm only able to work with the Test Environment right now I'm stuck with using what I have. The Column in one Table shows a Snapshot of a clients account which is set to VarChar(50) but the actual data in the column is formatted like a money format (with a $ and decimal point so for example "$5,000.00" would be an entry in one Row). 

What I'm trying to do is a create a WebService that will be used in a iPhone Application and one of the Methods needs to just give a quick display of the total value of all Clients with each specific company but I can't perform a SUM function on a VarChar column and I've tried to CAST and CONVERT the column into money, int, decimal and just about every format I can think of but I keep getting an error stating that I convert the data type varchar to which ever one I'm trying. I think it has something to do with the $ already listed in the Column, so I wanted to know what I could do to either remove the $ sign (like a Trim option) or if there is a better way of doing this that I can't think of.

Remove column from Listview


I'm binding a listview control to LinqDataSource and can't find a way to remove unnecessary columns.

How to remove auto generated right blank column from the wpf datagrid?


i have already use this.


remove headings on each column in dispform


We use MOSS 2007. When click an item in a list, the item is displayed in dispform.aspx.

Then we can see two parts, left column is something like Icon, Tilte, short description ..., right column is ther ereall contents.

How can we hide the left part, meaning to hide the headings of the columns, because it doesn't make sense to show them to users.


DropdownList not displaying spaces in column



I have a dropdownlist which is bound to a SQL Server 2008 Table.

My issue is i am having some spaces in one of the columns.

But while binding the datasource to this table the column spaces are truncated .

This is illustrated below

The table name is DataTable

DataValue is the column which I needs to get displayed in the dropdownlist

ID                                                                   DataValue

1                                                                    P2P 1111111111111111                             &nb

Update statement with CASE inconsistently updates VARCHAR column, stripping leading zeroes.


I have an update statement below that strips the leading zeroes off the front of AU. This value will have typically '0001234' or something like this. In my case statement, I have 2 scenarios: 1) when I use the commented out phrase (case when 1=1), the statement leaves AU alone as it should when the condition is met. 2) When I use the other statement, it STRIPS the leading zeroes off AU - I don't want it. I am just telling it to set it as is. Why is this doing this and what can I do to stop it. I was just attempting to set AU = AU in these conditions.

SELECT * from msdn.MSDN_Import1
UPDATE msdn.MSDN_Import1 SET MSDN.MSDN_Import1.AU =
--CASE WHEN 1=1                                                                       -- when I use this line, AU is untouched and stays AU = '0001234'
CASE WHEN NullIf(MSDN.MSDN_Import1.LOBCC,'') IS NULL            -- when I use this line, AU='0001234' becomes AU = '

remove Column header from List View Webpart


hi, i am having sharepoint 2010 Enterprise RTM trial on Windows server 2008 SP2. I wanted to know how a column header of a list in List View Webpart can be hide ?

i have tried the following article:


but i don't see any source editor in content Editor Weppart and also the Hidden button is disabled....

Is it necessary to do this task from code ?

How to remove white spaces - asp.net 4.0


hello everybody. i want to remove all white spaces at both html and javascript files. how can i achive this.


using iis 7.5

asp.net 4.0

asp.net web site project


thank you 

Remove Column from List Content Type


I have a list that inherits from 2 site content type.  When I added the "site content types" to my list it created a "copy" of it in my "List Content Type". 

Then I created a new column directly into my list, and at the bottom of the column creation screen there is a checkbox saying "Add to all content types" that was checked by mistake (I dont want the List Content types to have the column).

Now, is there a way I can remove those columns from the "List Content Type"? 

I saw that I can delete the "List content type" and re-link to the "Site content type", but I would need to delete all of my items before doing that, and I want to avoid that.



Search for Clustered Index in database on varchar, nvarchar column



I have very big database, i am running a Re-index job and it's keep failing throwing everyday error stating "Online index operation cannot be performed on clustered index as index contains column of data type text, nvarchar.

is there any way i can search and change all such datatype of culstered into non-clustered indexes or any better solution i have.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend