Trimming a query for search
I have a table named doctor where there is a field called doctorname where the names are like Dr. ABC, Dr. BCD . I have a search page where I can give an alphabet by which the doctor name is searched from the table containing the alphabet. But when i am giving the alphabet 'D' or 'r' or '.' the search result is returning all the names since the names are stored with the prefix Dr. . I have used like for searching names. What can i do to trim the first Dr. from the SQL query itself. any code will help.