RE: string parsing or list traversal

2003-01-22 Thread Lomvardias Christopher
One option would to be use a UDF (SQL2K). http://www.sqlteam.com/item.asp?ItemID=11499 Chris -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 2:52 PM To: CF-Talk Subject: string parsing or list traversal Does anyone know how to

RE: string parsing or list traversal

2003-01-22 Thread Tangorre, Michael
:-) wish i was on sql2K, but still on 7.0 Mike -Original Message- From: Lomvardias Christopher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 3:14 PM To: CF-Talk Subject: RE: string parsing or list traversal One option would to be use a UDF (SQL2K). http

RE: string parsing or list traversal

2003-01-22 Thread Matthew Small
http://www.showstopperonline.com -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 3:23 PM To: CF-Talk Subject: RE: string parsing or list traversal :-) wish i was on sql2K, but still on 7.0 Mike -Original Message- From

Re: string parsing or list traversal

2003-01-22 Thread S . Isaac Dealey
Does anyone know how to traverse a list of prse a string in T-SQL inside a stored procedure? What I need to do i send a comma delimited list into a stored proc then loop over the list inserting each entry into a table. Any help would be appreciated. Thanks, Michael T. Tangorre Yep...

RE: string parsing or list traversal

2003-01-22 Thread Dobris, Eric
I think this is exactly what you are looking for: http://www.sqlteam.com/item.asp?ItemID=256 Eric Dobris -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 2:52 PM To: CF-Talk Subject: string parsing or list traversal Does anyone

RE: string parsing or list traversal

2003-01-22 Thread Matthew Small
, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 3:42 PM To: CF-Talk Subject: RE: string parsing or list traversal I don't see why you'd have any problems doing this: Try something

RE: string parsing or list traversal

2003-01-22 Thread cfhelp
:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 3:01 PM To: CF-Talk Subject: RE: string parsing or list traversal Sorry, I messed up the instr function ( I don't think it's supported in SQL2K) I think you can use the charindex function instead. Also make sure to add an ending comma like Issac

RE: string parsing or list traversal

2003-01-22 Thread cfhelp
Oops Sorry. Rick -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 4:32 PM To: CF-Talk Subject: RE: string parsing or list traversal It has to do with feeling safe on the road when you are surrounded by these monsters that you cannot see