That's what I was looking for! So simple, I looked right over it:
substr(URL , 0, (instr(URL , '/', 1)-1))
Thanks for the inspiration! As a side note, this little application of these functions isn't anywhere on the internet! Somebody might want to pick this up & post it where it can be found again.....
- Eric




Reply With Quote