hi , i got porblem when iam trying to insert a string having an apostrophy (') into SQL Server 2000 from VB .. i.e the VB statement is : cn.open "insert into table1 values('"str"')" here my str=Raja's iam getting error with this syntax.. if str=Rajas it dosent give error. some one pls tell me how to insert strings like the previous one..

before using any strings in a query with sql server, replace any instances of ' with ''. str = replace(str, "'", "''") Good luck, -SN

thank u for your suggestion SN but it dosent work. if i make it double qoutes it is entering double quotes not ' . pls any one tell me how to insert (') into the data base ( sql server ). thank u .

Sunny- Sorry my suggestion didn't work. I'm quite certain that is how you do it though...Try running the query manually in Server Enterprise Manager or Query Analyzer: INSERT INTO tbl (field1) VALUES ('don''t eat yellow snow') and see if it puts in the single apostraphe. If it doesn't, perhaps there is some setting in SQL server that needs to be changed. If it works, then something is going on in your code (maybe accidentally performing the replace twice on the same string?) Luck, -SN