Re: [SQL] Search and Replace

2003-01-09 Thread Randy D. McCracken
On Thu, 9 Jan 2003, Ross J. Reedstrom wrote: > On Thu, Jan 09, 2003 at 11:00:32AM +0530, Rajesh Kumar Mallah. wrote: > > > > any anyone explain whats wrong with the replace based solution to this problem > > which i posted earlier? > > > > did i misunderstood anything? > > Probably just overkill -

Re: [SQL] Search and Replace

2003-01-08 Thread Randy D. McCracken
Just to close off another thread and to give a tad more information... I was not clear enough in my initial question to the list because not all of the URLs I am trying to change begin with http://www.srs.fs.fed.us/ so what I was really looking for was the syntax for replacing "www.srs.fs.fed.us"

[SQL] Search and Replace

2003-01-08 Thread Randy D. McCracken
s along wildcards so that I do not change the other parts of the complete URL. I have tried substituting "like" for "=" and trying to use the wildcard of "%" but to no avail. I am really just guessing here. Any help would be greatly appreciated! Best, --rdm