ToShort

The ToShort function converts numeric values and numeric strings to the short data type.

ToShort(<numeric or numeric string>)

Short

The minimum Short value is -32768 and the maximum Short value is 32767. The function will truncate any decimal values found in the input parameter.

select ToShort(-32768),
TypeNameOf(ToShort(-32768))
from Empty();

select ToShort('32767'),
TypeNameOf(ToShort('32767'))
from Empty();