MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

simple query error~ !! anyone help me..?thX
Posted by: Edmund Foong
Date: May 16, 2005 09:37PM

hi ALL,

i want to convert MsSQL database to MySQL. I having problem in converting the sql query below to suit the MySQL. Please help...



MsSQL : "SELECT cust_name1 + cust_name2 FROM table1"
OutPut : "David Foong" in single column


MySQL : how? because mySQL does not support "+" to concatenate string.



Kindly show me the query if possible..thanks alot...

Best Regards,
Edmund.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
simple query error~ !! anyone help me..?thX
Edmund Foong
May 16, 2005 09:37PM
Re: simple query error~ !! anyone help me..?thX
Felix Geerinckx
May 17, 2005 12:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.