i am using VB as client.& SQL server as DB.
when i try to store this text "khdfkhsdkfh'sdfsdf'" in a varchar field i hit error "incorrect syntax near'sdfsdf'"
its bcos the single quote. but i need to store this value.
is it bcos the datatype is varchar???