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!
SELECT CAST( description as varchar(100) ) Description
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.
(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#