limiting characters

hi there,

just curious to know if there is a way to display only a specific amount of characters in a description field on an asp page?

for example i have a description field in my DB but when displayed on my asp page i only want say 50 characters displayed (kinda like a brief description, but without having to create a new DB field for it).

i new to the development side and was just curious?

many thanks

mark

thanks for swift response

where would i place in this string?

<%=(rsResults.Fields.Item("Description").Value)%>

i have tried a few times but get errors?

thanks
mark

paste <%= Left(rsResults.Fields.Item("Description").Value),0,50) %>

where you want it displayied, after the connection is opened.

to stop at x words you could try the following

strDescTemp = rsResults.Fields.Item("Description").Value

saryDESC = split(strDescTemp," ")

intCounter = 1

do WHILE intCounter < Number of words

if not intCounter = 1 then strDesc = strDesc & "&nbsp;"
strDesc = strDesc & saryDESC(intCounter)

intCounter = intCounter +1

loop

you can try teh above code, please note that it hasn't been tested. if you get any errors please feel free to reply back.