Thank you! And I was so close, shouldn't it have just known what I
meant? :)

One question: what is I wanted to insert the word "now" into a string
field? I though that by using single quotes it would treat it as a string.

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
>
> You will kick yourself
>
> try this:
>
> INSERT INTO MYTABLE VALUES ('MyString','NOW');
>
>
> --- In firebird-support@yahoogroups.com, "ra8009" <ra8009@y...> wrote:
> >
> > I want to write an insert statement that inserts a string and the
> > current time into a table:
> >
> > INSERT INTO MYTABLE VALUES ('MyString',NOW);
> >
> > The SQL above doesn't work, it says that "NOW" isn't recognized.
> What
> > is the right way to do this?