string update problem in SQL

Question

Hi,

 

  I tried to update string "Test, test.1" it throws some error .. but if I remove the space as "Test,test.1" it updates properly.

 

kindly suggest how to update with space.

 

Thanks

Sathish.