Entry

How do I limit the amount of text that comes out of my 'Description' column to 440 characters?

Feb 20th, 2008 23:06
dman, Matt Chatterley, Shell Gellner, http://sturly.com

You could use LEFT() or RIGHT() as follows.
SELECT LEFT(Column, 440) AS Column FROM Table1;
This will return the left-most 440 characters of the value in the column.