> ... substring(thara_plane.bodytext,225) as bodytext > > I need to select the first 255 chars from the field "thara_plane.bodytext". hi lauri at first glance this looks okay -- assuming you take it out of the FROM clause and put it into the SELECT list ;o) substring syntax can be database dependant -- which database is it? rudy.ca