document.write('

SELECT CONCAT(LEFT(NameOfTextField,LOCATE(\' \',NameOfTextField,$CharactersToDisplay)-1),\'...\')
');
document.write('  FROM TheTable
');
document.write(' WHERE TheID = $TheID

'); document.write('

Brought to you by the community at byteMyCode.

');