Click here to Skip to main content
15,903,388 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Popup Callback Pin
Brady Kelly19-Nov-07 20:41
Brady Kelly19-Nov-07 20:41 
QuestionRemove Items From Listbox Pin
ShruthiLavan19-Nov-07 18:44
ShruthiLavan19-Nov-07 18:44 
AnswerRe: Remove Items From Listbox Pin
Christian Graus19-Nov-07 18:47
protectorChristian Graus19-Nov-07 18:47 
Questionsubstring function Pin
Sonia Gupta19-Nov-07 18:11
Sonia Gupta19-Nov-07 18:11 
QuestionRe: substring function Pin
Vasudevan Deepak Kumar19-Nov-07 18:31
Vasudevan Deepak Kumar19-Nov-07 18:31 
AnswerRe: substring function Pin
Sonia Gupta19-Nov-07 18:42
Sonia Gupta19-Nov-07 18:42 
AnswerRe: substring function Pin
Christian Graus19-Nov-07 18:32
protectorChristian Graus19-Nov-07 18:32 
AnswerRe: substring function Pin
Michael Sync19-Nov-07 18:37
Michael Sync19-Nov-07 18:37 
Check-out this SQL split function

http://www.devx.com/tips/Tip/20009

Here is my modified (0.1%) code.

DECLARE @String nvarchar (4000)<br />
DECLARE @Delimiter nvarchar (10)<br />
<br />
SET @String = '12,13,14'<br />
SET @Delimiter = ','<br />
<br />
declare @NextString nvarchar(4000)<br />
declare @Pos int<br />
declare @NextPos int<br />
declare @CommaCheck nvarchar(1)<br />
 <br />
 --Initialize<br />
 set @NextString = ''<br />
 set @CommaCheck = right(@String,1) <br />
 <br />
 --Check for trailing Comma, if not exists, INSERT<br />
 --if (@CommaCheck <> @Delimiter )<br />
 set @String = @String + @Delimiter<br />
 <br />
 --Get position of first Comma<br />
 set @Pos = charindex(@Delimiter,@String)<br />
 set @NextPos = 1<br />
 <br />
 --Loop while there is still a comma in the String of levels<br />
 while (@pos <>  0)  <br />
 begin<br />
  set @NextString = substring(@String,1,@Pos - 1)<br />
 <br />
  PRINT @NextString<br />
 <br />
  set @String = substring(@String,@pos +1,len(@String))<br />
  <br />
  set @NextPos = @Pos<br />
  set @pos  = charindex(@Delimiter,@String)<br />
 end<br />
 <br />


BTW, this is ASP.NET forum. (You have been here for long time so you know that, right? )Smile | :)



Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."

GeneralRe: substring function Pin
Sonia Gupta19-Nov-07 18:41
Sonia Gupta19-Nov-07 18:41 
AnswerRe: substring function Pin
InsDev19-Nov-07 19:09
InsDev19-Nov-07 19:09 
GeneralRe: substring function Pin
Sonia Gupta19-Nov-07 19:15
Sonia Gupta19-Nov-07 19:15 
GeneralRe: substring function Pin
Sonia Gupta19-Nov-07 19:27
Sonia Gupta19-Nov-07 19:27 
Questiondependent 2 select box list - how? Pin
VinothRao19-Nov-07 17:19
VinothRao19-Nov-07 17:19 
AnswerRe: dependent 2 select box list - how? Pin
Christian Graus19-Nov-07 17:30
protectorChristian Graus19-Nov-07 17:30 
GeneralRe: dependent 2 select box list - how? Pin
VinothRao19-Nov-07 18:42
VinothRao19-Nov-07 18:42 
Generaldependent 2 select box list - how? Pin
Sarani Ravindran19-Nov-07 18:59
Sarani Ravindran19-Nov-07 18:59 
AnswerRe: dependent 2 select box list - how? Pin
Vasudevan Deepak Kumar19-Nov-07 17:32
Vasudevan Deepak Kumar19-Nov-07 17:32 
Question[Message Deleted] Pin
jagan12319-Nov-07 17:11
jagan12319-Nov-07 17:11 
AnswerRe: how to retrieve the saved file path which is saved using save file dialog box Pin
Vasudevan Deepak Kumar19-Nov-07 17:31
Vasudevan Deepak Kumar19-Nov-07 17:31 
GeneralRe: how to retrieve the saved file path which is saved using save file dialog box Pin
jagan12319-Nov-07 17:34
jagan12319-Nov-07 17:34 
GeneralRe: how to retrieve the saved file path which is saved using save file dialog box Pin
Christian Graus19-Nov-07 17:38
protectorChristian Graus19-Nov-07 17:38 
GeneralRe: how to retrieve the saved file path which is saved using save file dialog box Pin
Vasudevan Deepak Kumar19-Nov-07 17:39
Vasudevan Deepak Kumar19-Nov-07 17:39 
AnswerRe: how to retrieve the saved file path which is saved using save file dialog box Pin
Christian Graus19-Nov-07 17:37
protectorChristian Graus19-Nov-07 17:37 
QuestionPHP VS ASP.NET for a youtube-like project Pin
Mohammad A Gdeisat19-Nov-07 15:30
Mohammad A Gdeisat19-Nov-07 15:30 
AnswerRe: PHP VS ASP.NET for a youtube-like project Pin
Michael Sync19-Nov-07 16:29
Michael Sync19-Nov-07 16:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.