remove decimal when Cast number to Varchar 1

[RustyAfro]

I have a simple cast statement

CAST(aNumber AS VARCHAR(10)) that makes the number

111

to

'111.'

Can anyone tell me how to do the CAST properly so that the decimal is not included in the casted string?

 

[blom0344]

try:

REPLACE(CAST (aNumber AS VARCHAR(10)),'.','')

OR:

CAST (INT(aNumber) AS VARCHAR(10))

Ties Blom

 

[RustyAfro]

I used the second solution. Thanks