Re: formatting numbers in sap business one query manager

On 8/21/2020 3:09 AM, Ammammata wrote:
> 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
> 

You should be asking this in an MS SQL newsgroup.  MySQL has more 
extensions and is a bit laxer in allowing violations of the standard 
than MS SQL is.

I'm not familiar with MS SQL so I can't help you there.  But you may not 
be able to find a good answer and have to do it in software.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
[email protected]
==================