Hi,

> I am having some difficulties porting following view from MSSQL2000
> to Firebird 1.5:
> CREATE VIEW "v_MDEntries"(
> "MdentryID",
> "DeclID",
> DLN,
> TIN,
> "FromDate",
> "ToDate",
> "TodID",
> "CantonID",
> "LOfficeID",
> "MD_UsrID",
> "MD_UsrTS",
> "OE_UsrID",
> "OE_UsrTS",
> "OE_Timer",
> "KV_UsrID",
> "KV_UsrTS",
> "KV_Timer",
> "EC_UsrID",
> "EC_UsrTS",
> "EC_Timer",
> "DecPosted",
> "DLNBlock",
> "Status",
> "StatusTS")
> AS
> select M.*, SUBSTRING(DLN FROM 1 FOR 14) as "DLNBlock",
> case
> when COALESCE("EC_UsrID", 0) <> 0 then 4

A quick remark: stop using those double quotes around
object names! It makes them case sensitive!!

With regards,

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