Gettin a piece of specified text from any field.
-
Hey, I have a database and it contains article table so this table contains two field named Header and Content. Then i wanna show this data in a gridview control but there are two pages. the first one contains just label which is used to show any article's header and another label which is used to show some piece of article's content text. But how can i show some piece of article's content text to the user. For example i wanna get 5000 letters from begining of an article's content which is preserved in database.It is said there is an query to handle this.But i couldnt find that query. Please help me. Thanks and regards..
-
Hey, I have a database and it contains article table so this table contains two field named Header and Content. Then i wanna show this data in a gridview control but there are two pages. the first one contains just label which is used to show any article's header and another label which is used to show some piece of article's content text. But how can i show some piece of article's content text to the user. For example i wanna get 5000 letters from begining of an article's content which is preserved in database.It is said there is an query to handle this.But i couldnt find that query. Please help me. Thanks and regards..
-
Use the SUBSTRING function (or SUBSTR for Oracle) like
SELECT header, SUBSTRING(content, 0, 5000)Thanks man :)