Find and replace single quotes in a sql query

**Anilrgowda** · 21-Oct-2007, 11:25 PM

Question: I have a data base that has some single quotes in the field EX: new''car. I want to query the data base to locate (and replace) these single quotes but for the life of me can't remember how to include them in a search string
such as: select * from database where field like '%''%' which of course wont work. I also want to replace these quotes with nothing so using the example above it would be new''car replace with newcar.

**Anilrgowda** · 21-Oct-2007, 11:25 PM

>select * from database where field like '%''%'
should work correctly. assuming that it is indeed a single quote, and not a backquote ` or other character ? or double quote " in there...

21-Oct-2007, 11:25 PM	#1 (permalink)
Anilrgowda Administrator Posts: 18,695 Join Date: Jan 2006 Rep Power: 10 IM:	Find and replace single quotes in a sql query Question: I have a data base that has some single quotes in the field EX: new''car. I want to query the data base to locate (and replace) these single quotes but for the life of me can't remember how to include them in a search string such as: select * from database where field like '%''%' which of course wont work. I also want to replace these quotes with nothing so using the example above it would be new''car replace with newcar. ------------------

21-Oct-2007, 11:25 PM	#2 (permalink)
Anilrgowda Administrator Posts: 18,695 Join Date: Jan 2006 Rep Power: 10 IM:	Re: Find and replace single quotes in a sql query >select * from database where field like '%''%' should work correctly. assuming that it is indeed a single quote, and not a backquote ` or other character ? or double quote " in there... ------------------

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)