Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!iuvax!silver!bbeckman From: bbeckman@silver.ucs.indiana.edu (Beth Beckman) Newsgroups: comp.databases Subject: Easy Oracle question Message-ID: <47469@iuvax.cs.indiana.edu> Date: 13 Jun 90 03:06:57 GMT Sender: root@iuvax.cs.indiana.edu Organization: Indiana University, Bloomington IN. Lines: 7 I am trying to load a row in an Oracle table using the insert command. My question is: how do you format the command to insert a value containing an apostrophe? Example: Insert into tablename values ('President's Office'). Obviously, it is interpreting the apostrophe after the 't' as the end of the field. Thanks for your assistance! Beth bbeckman@silver.ucs.indiana.edu