Using Single Apostrophe while inserting data

[Faisal Saleem]

Dear fellows,

I want to insert the data in a field which contains apostrophe['] in it, but the insert command does not stores the test after apostrophe

e.g
Insert into test_tbl(id,name)
values (32,'This is a test of apostrophe's ...'

the above command does not store after first apostrophe.

Please suggest
-Faisal

[Judith Farber Abraham]

Try doubling every apostrophe you want to have in your data


------------
Faisal Saleem at 3/16/99 7:28:18 AM

Dear fellows,

I want to insert the data in a field which contains apostrophe['] in it, but the insert command does not stores the test after apostrophe

e.g
Insert into test_tbl(id,name)
values (32,'This is a test of apostrophe's ...'

the above command does not store after first apostrophe.

Please suggest
-Faisal

[Gregory]

or:
Insert into test_tbl(id,name)
values (32,"This is a test of apostrophe's ..."
....?


------------
Judith Farber Abraham at 3/16/99 7:32:16 AM

Try doubling every apostrophe you want to have in your data


------------
Faisal Saleem at 3/16/99 7:28:18 AM

Dear fellows,

I want to insert the data in a field which contains apostrophe['] in it, but the insert command does not stores the test after apostrophe

e.g
Insert into test_tbl(id,name)
values (32,'This is a test of apostrophe's ...'

the above command does not store after first apostrophe.

Please suggest
-Faisal