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.
| Author |
Topic |
|
sponguru_dba
Yak Posting Veteran
93 Posts |
 Posted - 2005-12-16 : 09:10:53
|
| Hi allIs theire any ANSI standard concatenationi mean ANSI standard SQL statement |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-16 : 09:13:32
|
| In SQL Server you can concatenate columns bySelect col1+','+col2 from yourTableprovided both are of varchar datatype otherwise you need to convert them to varcharIs this you are asking for?MadhivananFailing to plan is Planning to fail |
 |
|
|
sponguru_dba
Yak Posting Veteran
93 Posts |
Posted - 2005-12-17 : 04:04:16
|
| Thanks MadhivananBut i need query which is eligible work on both ms-sql server and OracleThanks in Advancesree |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-19 : 00:10:06
|
| In Oracle I think there is function called ConcatMadhivananFailing to plan is Planning to fail |
|
|
|
sponguru_dba
Yak Posting Veteran
93 Posts |
Posted - 2005-12-19 : 03:29:20
|
quote:
Originally posted by madhivanan
In Oracle I think there is function called ConcatMadhivananFailing to plan is Planning to fail
Yaa Madhavan oracle having concat and || for concatenatebut is it possible with out using '+' in sql server |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-19 : 03:53:14
|
| No. You need to use +MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Hi help needed ANSI standard concatenation