Hi,

> I have just stumpled over some text saying something about this being
> wrong:
>
> Select
> a.Fielda,
> a.Fieldb,
> b.Fieldc,
> b:fieldd
> where
> a.Fielda=b.Fieldb and
> a.Fielde>"Some value"
> ordre by a.Fieldb;
>
> Is this wrong in any way ?

String values should be enclosed in single quotes:

> a.Fielde>'Some value'

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."