Hello I am working on a database where i have a table that contains a field that has a url field. What I am trying to do is write a query that will give me the root domain and none of the sub domains.
Example: If I have the urls.... tek.tek-tips.com and tek.tips.tektips.com I want my query to be able to just capture tek-tips.com. I have had no luck doing this and the syntax I was attempting was:
SELECT URL.URL, InSTR(Left(,(InStr(1,[URL],".")-1))) AS PartI,...ot about SQL. Any help would be appriciated.
Example: If I have the urls.... tek.tek-tips.com and tek.tips.tektips.com I want my query to be able to just capture tek-tips.com. I have had no luck doing this and the syntax I was attempting was:
SELECT URL.URL, InSTR(Left(,(InStr(1,[URL],".")-1))) AS PartI,...ot about SQL. Any help would be appriciated.
