Free Jobs
Reference




Dot Net Forums: ASPNET (77) C#.NET (39) VB.NET (8) AJAX (21) Silver Light (1) WCF (10) WPF (1) WWF (1) .NET 3.5 (3) SQL SERVER (38) Other (3)

Topic: How to break two string delimited in sql stored procedure

To get the Posted Questions details daily in your mail Click Here

Share this Post on Facebook/Twitter/Orkut Bookmark and Share





User: manishav3388 Post Date: 23 May 2012 13:03

Introduction:
How to break two string delimited in sql stored procedure



Main Content:

declare @return_value varchar(200)


 

declare @delimiter varchar(1)

set @delimiter ='',''

declare @index int

set @index = CHARINDEX(@delimiter , @return_value)

print @index

print LEFT(@return_value, @index-1)

print RIGHT(@return_value,((LEN(@return_value)- (@index))))





 


Conclusion:
this way we can break two string delimited in sql stored procedure



About Writer:
hello,I am JAVA Developer from Noida.


Writer's Link: http://

Writer's Email:







Comments:
Post Comment





Similar Articles Top ArticlesLatest Articles Other Articles by this Author







www.freejobsreference.com Copyright © 2009-2011 | All Rights Reserved
All content of this website is protected by copyright laws and should not be reproduced in any form or by any means without written permission
(Best viewed in IE 8.0+ or Firefox 3.0+ at resolution of 1024 * 768 or higher)