MS SQL COLUMNS CONCATENATION EXAMPLE

2 Feb

Ref:http://www.sqlbook.com/SQL/SQL-CONCATENATE-24.aspx

Example:

Select [x], [y], [icon], [icon_size],[shadow], [shadow_size],[id],[anchor], [zone_id], [cat_name], name +'<br>’+ SUBSTRING(description, 1, 125) as name,[name] as nameo, [addr], [town], [rates], [phone], [webpage], REPLACE(description, ‘<br>’,”) as description, [town], [image_1] From [table_name]

Advertisements

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

%d bloggers like this: