Simple Select Statement to return data containing Single Quote

[woogoob]

I have a table with some data that contains single quotes.

eg...
Table: tbl_Tools
Column ITEM
Data...
Garden Hose 50'
PVC Pipe 25"

Can someone tell me the SQL statement to return records that contain single quotes. I want to use 'IN' in the WHERE clause because I have a list of items i want to look for.

eg...
Select * from tbl_Tools Where Item IN ('Garden Hose 50'','PVC PIPE 25"')

The above statement fails because of the single quote in the data.

Thanks in advance,
Gary

 

[woogoob]

I figured it out...double up single quotes

 

[SamGarland]

Use two consecutive ' (single quote) characters inside a string (which is itself delimited with single quotes) to denote a literal ' character.

For example:

use pubs
select au_lname from authors where au_lname like '%''%'

au_lname
----------------------------------------
O'Leary

(1 row(s) affected)