How do I display the first 30 characters from a database memo field?

[stredovek]

I can display all data in memo field in browser. But I want display just part of information.How?

[txbakers]

Hi and welcome to the Webmaster World forums!

For something like this I would create a new variable and assign the db value to that.

Then, you have a bunch of choices.

You could run a simple loop building the new variable up to 30 characters.

You could also do a Substring command to extract the first 30 characters.

It's not difficult.

[jimmykav]

use the Left() function for the left most chars in a string or the Mid() to get a sub section of the string or the Right() function for the rightmost xx chars.

[duckhunter]

Since it's a memo/text field you may have to convert it to a VarChar before performing left/mid/right.

Select convert(varchar(3),myfield) from ....

[macrost]

I have had no problems with this:
Left(index(3)), however, I do replaces special char's with their respective hex equivalents.
Mac
<added>Also, using the Left or Right does count spaces too, so if you want the first 30 chars, you will have to account for that too.</added>