Re: Special characters in timesten db?

Adam wrote:
>
> How do you enter a statement like:
>
> update locations set name = 'bob's room'
>
> I keep getting exceptions on the apostrophe.
>
> Thanks in advance.

For Standard SQL, you double embedded quotes:

update locations set name = 'bob''s room'

See the SQL Tutorial on literals -- http://www.firstsql.com/tutor3.htm#literal.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)
.