Inline code SQL 2005
-
I have table A with col1, col2 & table B with col3, col4. I would like to write a query like select 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
-
I have table A with col1, col2 & table B with col3, col4. I would like to write a query like select 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
Anything wrong with google today? Have a look here[^]. String concatenation has been around as long as SQL has. But different dialects have different syntax. Oracle uses '||', Sql Server uses '+', most implementations can use 'concat(string1, string2)' but not SQL Server AFAIK. Could be wrong about that though.
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions
-
Anything wrong with google today? Have a look here[^]. String concatenation has been around as long as SQL has. But different dialects have different syntax. Oracle uses '||', Sql Server uses '+', most implementations can use 'concat(string1, string2)' but not SQL Server AFAIK. Could be wrong about that though.
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions
Jörgen Andersson wrote:
Anything wrong with google today?
Same impression here, I'm starting to believe I'm the only person with Google access today :)
Full-fledged Java/.NET lover, full-fledged PHP hater. Full-fledged Google/Microsoft lover, full-fledged Apple hater. Full-fledged Skype lover, full-fledged YM hater.