Hi Laurie,
> how do I insert the following
>
> INSERT into phone (INITIALS,NAME,PHONE_NO,SUBURB) Values
> ('AC','O'Hara','0413000153','Seafort ')
You can indicate a quote within quotes, by using two quotes.
Do it like this:
INSERT into phone (INITIALS,NAME,PHONE_NO,SUBURB) Values
('AC','O''Hara','0413000153','Seafort ')
Tom
BareFeet
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
