Hi Adil:
You can use following .
select concat((select name from test where tcid=1),(select name from
test where tcid=2));
or
select concat('hello','World');
For more details visit MySQL manuals.
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
here you can find some more Examples.
Thanks
Sumit
--- In [email protected], adil kazmi <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I m very new in MYSQL and previously working on SQL
> Server.I have a problem in Concatanation of
> strings.Can anybody tell me the solution.
> suppose I want to concat the two string 'ABC' and
> 'DEF' and want O/P like- ABC DEF
> so how would I write the Query for that???
>
>
> Thanks
>
> Adil
>
=====================================================
Mark your calendar for the next TSM
Saturday (5pm - 7pm) on 16th September 2006
AJAX Live
- Core Ajax components
- How to write Ajax code
- Lots of Ajax demos
Venue:
5th Floor, Conference Room
CommVault Systems (India) Pvt Ltd.
Ashoka Janardhan Chambers
S.P. Road, Begumpet
Hyderabad.
Helpline:
+91 - 98482 37656
To know more about TWINCLING Society
http://www.twincling.org/
=====================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/twincling/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
