Multiple choice sql

What will be the output of the following statement? SELECT STR(6365, 3)


  1. 6365

  2. 6,365

  3. 6400

  4. 6365.000

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The STR function converts numeric data to character data. The syntax is STR(number, length). If the specified length (3) is shorter than the number of digits in the value (6365), SQL Server returns asterisks to indicate an overflow.