Yeah, sure "left". (what a stupid chick am I?)<BR><BR>But I thought of something more faster, directly executed by the DB Server. See, sometimes I have 50-120 KB of text in a memo field, pulling that into a recordset (memory) eachtime foreach visitor can be rather exhausting for the server when dozens of visitors surfing the site... (at least I think so...)<BR><BR>Jenny
Perform the string manipulation on the server then, that will spare some bandwidth. Both Access and SQL Server support the Left function:<BR><BR>SELECT LEFT(FieldName) FROM Table<BR><BR>Although in SQL Server it might even be better to simply convert the text field to a [var]char(50) field:<BR><BR>SELECT Cast(FieldName as varchar(50)) FROM Table<BR><BR>Jeremy_D<BR>
That is a good idea...It is generally best to do any work that you can on the DB server..(One reason SQL Server and Oracle's ability to handle stored proc's is so nice)<BR>Glad you got it solved.