i want to show 35 words out of 100 or more words .how can i do it? pls help me.

Can you elaborate to us what is that you are trying to accomplish so that we can be of better help to you? "Just one line post" doesn't explain what you are trying to do.

Cheers.

_________________________
- Vijay G
Strive for Perfection

using SQL SERVER 2005 i want to show 35 words(not character) out of 100 or more words .how can i do it in SQL?.i used substring but it works on character and doesn't show full words (in last,show half words) and its impossible to count character of a senrtence which contains uncountable words .how can i do that?

Is that you want the first 35 words to be shown? If so you need to parse through the string and look for white space, count the white space that many times you want the number of words show, and print the content until that.

Hope that explains.
Cheers

_________________________
- Vijay G
Strive for Perfection

If you are going to show the first 35 words to the user using an application, the easiest way is for you to do this from that application. If you really need to do it in SQL, what you can do first is to convert that string into a table. Here's a link which you can use, but this assumes that the separator is a comma. Simply modify it to use space instead:

http://www.sql-server-helper.com/fun...-to-table.aspx

Then once you have it in a table, put them back together but using only the first 35 words. Here's another link that may help you achieve that:

http://www.sql-server-helper.com/tip...ed-output.aspx

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp