Retrieving part of text from database

[savelam]

Hello, am working on a project that retrieves part of a text from a database and then tells the user to read more.

For example, if I have "Programming is good.And everyone practice to know" and I want to retrieve only "Programming is good." but because the text is very long, I want only say some of the text but with fullstops at the end so that users reading the text can have some understanding before clicking on the READMORE button.

eg. "SELECT text SUBSTRING(text,1,20) as text FROM dbname";

how do i write it so that it brings the next available fullstop ?

Please help me.

[Weedpacket]

Look at the documentation of your DBMS to see if it provides a function that allows you to search for a particular string. Use that to find the first full stop, and use that in your SUBSTRING.

[savelam]

thanks will try and give you a feedback