Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Substring function that return n words ...

Author  Topic 

hapytran
Starting Member

8 Posts

Posted - 2005-09-11 : 23:37:00
Hi all,
I want to get a subtring of decription field in database. But, if i use "LEFT" function, the result maybe like this "This is a t...", instead "This is a topic ...". I want the result is returned n words. Any one write this function in SQL Server?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-12 : 00:42:37
Post the full Description of that field and the result you want from that

>>I want the result is returned n words

If you mean splitting the words, refer this
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -