I'm executing this TSQL Code:

```
DECLARE @myString varchar;
SET @myString = '123.0'
SELECT CAST(@myString as decimal(25,10))

```

But I keep getting 1.00000 as an result
Changing myString to '123' doesn't change that.

Any advise on what I'm doing wrong is appreciated.

Thanks in advance!