[thelist] substring and a join?

rudy r937 at interlog.com
Sun Mar 4 10:17:02 CST 2001


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





More information about the thelist mailing list