Hi,
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.

Hi
  you can use
   mid(doctorname,4) like '<searchstring>'
         - for access database and
   substring(doctorname,4,len(doctorname)-4) like '<searchstring>'
         - for SQL database


Regards
Raj