Re: inserting single qutoes in string???

In article <Atomic.software.1178260528D_at_newshost.lanl.gov>, Atomic.software_at_pobox.com (Allan Marcus) writes:
|> is there a way (from sql*plus) to insert a single quote in a varchar field?
|> This is, of course, a problem since the single quote usually delimits a string.
|>

Inside a string, put two single quotes next to each other. For example: 'Scott''s string'. Thus the string consisting of a single single quote would be '''' - the first quote delimits the start of the string, the next two are the only character in the string (a single quote) and the last one delimits the end of the string.

|> Thanks,
|>
|> Allan Marcus
|> "My opinions are my own, I think..."
|>
|>
|> AppleLink: Allan.Marcus
|> CIS: go ATOMIC, section 7
|> InterNet: Atomic.Software_at_pobox.com
|> eWorld or NewtonMail: Allan.M
|> AOL: Atomic.Software_at_pobox.com
|> Day Job email: allan_marcus_at_lanl.gov
|> Day Job Voice: 505-665-1828
|> Home Voice: 505-672-0370
|> -------------------------------------------------
 

-- 
Scott Urman
"The opinions expressed here are my own, and are not necessarily that of
 Oracle Corporation"