ASP/SQL Query Recordset up to 200 characters?

[Speegs]

Is it possible through SQL to query a recordest lets say a memo description feild for lets say only the first 200 characters?

Or

To somehow control this through CSS?

Please advise.

Speegs

[webshorts]

The easiest way is to simply pull the first 200 characters using VBScript:

<%= Left(yourRecordset('yourMemoField'), 200) %>

That would do it :)

[Speegs]

Thanks Daniel, it worked like a charm.
What is the significance of left? Just curious, also would it be possible to tell it to stop at the first period or end of sentence it finds.

Speegs

[DavidT]

Actually, you could do this in the query even easier (well, the same way at
least)

SELECT left(yourFirld,200) as 'myMemo'...

that way you don't have to deal with it on the page. Of course this will
truncate the field for ALL records but that seems to be what you want. Look
up INSTR functions to stop at the 1st period or anything else.

Left syntax is "starting from the LEFT return the N number of characters
from the given field". It's one of the basic SQL commands or other
programming languages with string variables.

HTH

David


"Speegs" <webforumsuser@macromedia.com> wrote in message
news:d1bk4k$nfu$1@forums.macromedia.com...

> Thanks Daniel, it worked like a charm.
> What is the significance of left? Just curious, also would it be possible

to tell it to stop at the first period or end of sentence it finds.

>
> Speegs