HI
In my table, I fields like Name, URL, ID. The urls are like http://www.google.com, etc. I want to extract just host name like google.com. I want to get the output like below when I wrote query such as "SELECT ID, NAME, URL FROM MyTable"
ID Name URL
1 abx google.com
2 xyz yahoo.com
3 pqr cricinfo.com
Any help on this ?