Here is the entire query:

SELECT CASE

WHEN orig.orig_system is null or orig.orig_system = 'UNKNOWN'

THEN 'ORACLE'

...

this is the error i got now:

Msg 8114, Level 16, State 5, Line 2

Error converting data type nvarchar to float.

does this pl/sql equal this tsql, it is giving me errors when i run it.

PL/SQL

select /*+ RULE */

decode(orig.orig_system,null,'ORACLE','UNKNOWN','ORACLE',orig.orig_system)||'|'||nvl(orig.orig_system_reference,ca.orig_system_reference)||'|'||

...