database change

[Nicky Koller]

I was using this code for an Oracle database and now the same database (accpac) is now been moved to an SQL database. A simple select query works, but not the following query.

select distinct substr(trim(a.a cctid) ,length(trim(a. acctid))-3,4) as vAccount,a.ACCT DESC from GLAMF a
where length(substr(t rim(a.acctid) ,length(trim(a. acctid))-3,4)) >= 4

Any suggestions would be most welcome

[JosAH]

Oracle also understands SQL but the ISO SQL Standards (e.g. 1992, 2003) are
too weak to make those vendors understand that their 'extensions' to the SQL
language are not SQL. Oracle extensions are not the other vendor's extensions
and vice versa and that's why moving from one SQL database to another one is
such a PITA.

kind regards,

Jos