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 ?