Thanks to all. I already solved the issue by using insert and update. Before I was just using the insert statement. it was really very simple, as mentioned by you...

Thanks for the reply.

I am using Sql Server Express 2005, I think SSIS option is not available in it. And what about striping HTML tags from the text, did SSIS...

Thanks for your reply.

Actually I got the basic information for full text search. Now I am confused between data types. That what data type I need to use in...

Hi everyone,

Back to my problem. I am using VARCHAR() as my data type. Non of the column values holf CHAR().

Thanks

Yes Jeff you are right. I am having this problem in all of my tables. All the values have extra spaces on the right. You can easily see this by...

Thanks Jeremy for your tip. I already did by using Update, but the problem was that in resulting value it adds space between two values something like this "ABC ...

Thanks for the reply. This give me some hope.

I read the article and will give it a try tonight. Just want to know couple of things for instance how far...