Simple question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Will Honea - 29 Apr 2005 06:56 GMT

Not feeling especially sharp tonight, I couldn't find the reference to
this:

given:
select * from table where name = 'text'

What is the correct esacpe character to use when 'text' is a name like
O'Malley? I' drawing a blank in a serious senior moment.

Signature

Will Honea

Reply to this Message

Mark A - 29 Apr 2005 08:02 GMT

> Not feeling especially sharp tonight, I couldn't find the reference to
> this:
[quoted text clipped - 4 lines]
> What is the correct esacpe character to use when 'text' is a name like
> O'Malley? I' drawing a blank in a serious senior moment.

two single quotes

select * from table where name = 'O''Malley'

Reply to this Message

Will Honea - 29 Apr 2005 08:14 GMT

> > given:
> > select * from table where name = 'text'
[quoted text clipped - 5 lines]
>
> select * from table where name = 'O''Malley'

Thank you. Slaps forehead, muttering "of course!".

Signature

Will Honea

Reply to this Message