mmalik15
asked on
Extracting Summary from VARCHAR Data SQL SERVER 2000
Hi:
I already got help regarding this question but at the other end i got another issue:
Last Question: How to limit the varchar field size in SQL SERVER SELECT Statement!
Solution:
SELECT CAST( description as varchar(100) ) Description
from MyTable
Yes it worked for me but when CAST function trim the string it dont care about the complete words, as it some time cut the words (at the end of string) from middle. But i want to get complete words.
Example:
(i want like that )
Description: This is a brief description of country....More
(i am getting like that)
Description: This is a brief description of cou
FYI: Technology: SQL SERVER 2000, C#
I already got help regarding this question but at the other end i got another issue:
Last Question: How to limit the varchar field size in SQL SERVER SELECT Statement!
Solution:
SELECT CAST( description as varchar(100) ) Description
from MyTable
Yes it worked for me but when CAST function trim the string it dont care about the complete words, as it some time cut the words (at the end of string) from middle. But i want to get complete words.
Example:
(i want like that )
Description: This is a brief description of country....More
(i am getting like that)
Description: This is a brief description of cou
FYI: Technology: SQL SERVER 2000, C#
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks