quote:

---

...btw, sorry to the original poster!

I wasn't aware of the PARSENAME function.

Sounds really handy for such situations.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

---

Yes. I was surprised to see a script someone had posted for a function to split up ip addresses stored as strings; PARSENAME makes that rather easy.

--Jonathan