Hi James,

> I didn't notice but just now both of you have almost the same name :-)
>
> Martin
> I have no store procedure also ... :-(
>
>
> Martijn
>
> But if I try this
>
> SELECT Key, ID, Paydate
> FROM Counterpayments
>
> Iam getting an error.

Of course.

> What should be the right way?

Because you created your table with the use
of delimited identifiers, you have to continue
using them. I would avoid delimited identifiers,
because they are a "pain in the ...ss"

What admin tool are you using?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com