And CHARINDEX takes a StartLocation parameter. > -----Original Message----- > From: thelist-bounces at lists.evolt.org > [mailto:thelist-bounces at lists.evolt.org]On Behalf Of r937 > Sent: Wednesday, February 28, 2007 10:56 AM > To: thelist at lists.evolt.org > Subject: [thelist] mssql split (You out there Rudy?) > > > > Unfortunately, this is going to run only via a stored proc > > fortunately, you are allowed to loop inside a stored proc > > ;o) > > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! >