How to display 1ast 100 characters from database
4/16/2004 9:45:17 PM
how To display 1st 100 characters from database
hi!! does anyone knows how To display the first 100 characters of a database record? normally i would use <%=rs(""recordName"")%> To retrieve And display a record And it displays the entire field content, Is there anyway To limit the number of characters To display??? pls advise.. thanks!!
4/16/2004 10:09:34 PM
Re: how To display 1st 100 characters from data...
You cound Do the following In your query
Select Left(field,100) As short_field FROM....
Response. Write Left(rs(""field""),100)
Hope that helps :)