Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Remove spaces in all columns

Author  Topic 

saranram_forum
Starting Member

9 Posts

Posted - 2009-06-08 : 03:11:42
Hi,
I have problem after exporting excel data to sql server. I got whitespaces in columns and I need to remove whitespaces in all columns in a single query. I can remove the whitespaces single column at a time.But I need to remove whitespaces in all columns at a time.Is there any possiblity to remove whitespaces in all columns at a time? Please provide solution.


Saravanakumar

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-06-08 : 03:16:56
maybe you can modify the query from here http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -