Tutorial 7 - Adding an Apostrophe into a column using SQL

Question: How do I add an apostrophe into a column using SQL?

Solution: Although many people abuse the apostrophe there's a lot of times when it needs to be used.

Example:

INSERT INTO SLOGANS
(FULL_NAME, SLOGAN)

VALUES
('Andrew Krone', 'It''s time Andy''s website stopped boring people');



Hope everyone can see the double quotes, pretty simple stuff.
-Andy


0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home