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 |
|
ynainamoh
Starting Member
1 Post |
 Posted - 2012-09-16 : 01:34:06
|
| I have table A with col1, col2 & table B with col3, col4.I would like to write a query likeselect a.* from A join B on A.col1=B.col3 and A.col2 like col4 + '%'Is it possible in SQL 2005?is there a concat function in SQL 2008 or 2005. I have seen it in 2012.Pls help me.Thanks in advance |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-16 : 01:49:45
|
| You'll need to use '+'Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Inline SQL code