Re: formatting numbers in sap business one query manager

Il giorno Thu 20 Aug 2020 07:44:55p, *Jerry Stuckle* ha inviato su 
comp.databases.mysql il messaggio news:[email protected]
september.org. Vediamo cosa ha scritto:

>> I tried it: SAP B1 gives an error so I used round(x, 0) but the result
>> didn't change
>> 
> 
> What error does it give?
> 
> 

syntax error, truncate does not exist in the SLQ I'm using, that's NOT 
MySql but MS Sql

Msg 156, Level 15, State 1, Line 43
Incorrect syntax near the keyword 'truncate'.

My hope was to find a solution that worked on both systems

-- 
/-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
-=- -=- -=- -=- -=- -=- -=- -=- - -=-
........... [ al lavoro ] ...........