Hi there

I've got an asp page that reads some data from a table in a database.
In one of the columns I'd like to truncate the text/content supplied from the field in the database so it only displays a certain amount of words on the page.

Is there a way to do this?

thanks

Adam

You can use substring function in SQL query to return only part of data.



Om Prakash

OK, how would I go about doing that if this is my query?

strSQL = "SELECT * FROM Categories WHERE CategoryID = 1"


thanks

Adam,

Not sure, if you are using ACCESS DB or SQL server DB.

You can use SUBSTRING as om_prakash suggested, and alternately you can also use LEFT function

Select LEFT(COLUMNNAME, 20) from TABLENAME

Shows first 20 characters of that column for all rows.

Hope that helps.
Cheers!

_________________________
-Vijay G
Strive for Perfection

thanks guys - I've got it now