DA Morgan wrote:
> berwiki wrote:
>> Can anybody help me? This query executes perfectly fine in MSSQL, but
>> I get errors in Oracle.
>>
>> SELECT
>>
>> CAST(REPLACE(STR(SHCLOG.origtrace,6,0),' ','0')AS CHAR(6)) as
>> FIXEDTRACE,
>> SHCLOG.SETTLEMENT_DATE,
>> SHCLOG.MSGTYPE,
>> SHCLOG.ORIGMSG,
>> SUBSTRING(SHCLOG.PAN,1,6) AS ISOBIN,
>> SHCLOG.PCODE,
>> SHCLOG.TXNTYPE,
>> CONVERT(char(13), (CAST((SHCLOG.amount) as money)),1) AS FIXEDAMOUNT,
>> ' '+CAST(REPLACE(STR(SHCLOG.origtrace,6,0),' ','0')AS CHAR(6)) AS
<snip>
Does Oracle support + as a synonym for || ?
I thought that was a TSQL only feature.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/
Received on Fri Jul 14 2006 - 12:26:35 CDT