openmind — Wed, 08 Dec 2004 18:22:59 +0000

or in ColdFusion:

#Left(variable, 7)#

just wanted to round off the choices!

mjs416 — Wed, 08 Dec 2004 17:27:52 +0000

Splendid. Thank you very much. =)

Greg K — Wed, 08 Dec 2004 17:22:45 +0000

In your SQL query itself you can do the following:

$query = "SELECT LEFT(fieldname,7) FROM table";

In the server side script itself, assuming the data you want to truncate is in variable:

in PHP, substr(variable,0,7);

in ASP, not sure, but if it's like VB, left(variable,7)

-Greg