Replace tab in MS SQL

July 14, 2010 at 4:53 am Leave a comment


Replacing a tab with something else in MS SQL is easy peasy, following is the code

update [table name]
set [column name] = REPLACE( [column name], CHAR(9), ' ')
Advertisements

Entry filed under: MS SQL.

Direct Debit Service Providers and Solutions cfhttp I/O Exception: peer not authenticated Error

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 19 other followers

Archives

Top Rated

Top Clicks

  • None

Blog Stats

  • 169,146 hits

%d bloggers like this: