Re: apostrophes in an SELECT SQL statement

Jason Byors asks:  

> How could the following SELECT SQL statement be written so that it
> will work:
>
> SELECT * FROM movies WHERE title = 'Muriel's Wedding'
 

To specify an apostrophe inside of a string literal, double up the apostrophe like this:  

  select * from local_bars where name = 'O''Connor''s Tavern';  

• Lance (it's Friday, and I've got happy hour on my mind)