Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Concat_ws
Message
From
27/05/2006 16:29:20
Sergey Berezniker
New York, United States
 
 
To
27/05/2006 03:38:08
Winan Jaya
Jakarta, Indonesia
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Concat_ws
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01125483
Message ID:
01125524
Views:
15
You can use "+" operator to concatenate string but you'll have to add separator in between and handle NULL values yourself.
* mysql
CONCAT_WS(separator,str1,str2,str3)
* MS SQL
str1 + separator + str1 + separator + str3
>At MySQL I can use concat_ws for Concatenate With Separator .. what is similar function of concat_ws in SQL server? ..
>
>
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform