select query in this format

Posted by Dn2010 under ASP.NET on 4/18/2012 | Points: 10 | Views : 819 | Status : [Member] | Replies : 1
hi friends,

how to this query in mysql,


select ('+1-' +left( src , 3 )+ '-' + substring( src , 4 , 3 )+ '-' + substring ( src , 7 , 4 )) as src from mytable

please give the solution,

its urgent.




Responses

Posted by: Sabarimahesh on: 4/19/2012 [Member] Bronze | Points: 25

Up
0
Down
This is mysql to ms sqlserver Convertor


http://gathadams.com/2008/02/07/convert-mysql-to-ms-sql-server/

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response