Limiting amount of text retrieved from column

[Shaolin]

Hi Guys

Is there a way I can limit the amount of text I recieve from a certain column in DB ? I only want to display the first 100 characters of a 300char block of text.

[NogDog]

In MySQL you can use the SUBSTR[ING]() function (http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substring). Most other DBMS's will have a function with the same or similar name/functionality.