Francisco Tapia
fhtapia at gmail.com
Fri Sep 2 10:47:01 CDT 2011
are you trying to find each instance of a string within a field? if so that is an interesting approach, let me know how it performs, I'm curious. -Francisco http://bit.ly/sqlthis | Tsql and More... <http://db.tt/JeXURAx> On Fri, Sep 2, 2011 at 12:57 AM, Mark Breen <marklbreen at gmail.com> wrote: > Hello Francisco, > > I spent an hour or two yesterday morning working on my script, and I have > to > avoid temptation this morning to do the same. > > However, I cannot wait to try to implement your examples where. > > To further extend the exercise, I discovered yesterday that I may have > multiple occurrences of the search string, and I need to capture each > occurrence. Yesterday morning, I was experimenting with finding a column > where the string exists and then using a while loop to and charindex to > search for all occurrences. Does that sound right to you? > > Thanks for the articles, I will work on them and post back my results when > I > have something useful to post. > > Mark > > > > On 31 August 2011 17:07, Francisco Tapia <fhtapia at gmail.com> wrote: > > > I wrote up a script that leverages another developer's solution, I > co-wrote > > this article with Susan Harkins... > > > > http://www.devx.com/dbzone/Article/42340/1954?pf=true > > > > maybe you can extend or improve on what i've done to help leverage, I'm > not > > sure if the link will prompt you to have a free login account (i may have > > my > > browser cookies saved, if so I'll re-post the script here) > > > > http://www.devx.com/dbzone/Article/42340/1954/1763?supportItem=1 > > > > > > -Francisco > > http://bit.ly/sqlthis | Tsql and More... > > <http://db.tt/JeXURAx> > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >