Question: How to remove the zeros

```
  select CONVERT(varchar, CAST( -3563338 AS money), 1)

```

Output

```
-3,563,338.00

```

Expected Output

```
-3,563,338

```

Answer: 
Use `FORMAT`:

```
SELECT FORMAT(-3563338,'#,###,##0')

-3,563,338

```

The money type output includes a decimal component for change. But, since you don't want to see that it might be easier to just use `FORMAT` instead.
this will work:

```
select TO_CHAR(-3563338.00,'99999999') from dual;

```