Which of the following queries that use string functions will return the result 'aus'?

Select from following answers:

1. DECLARE @testvalue nvarchar(20); SET @testvalue = 'australia'; SELECT LEFT(@testvalue, 3);
2. DECLARE @testvalue nvarchar(20); SET @testvalue = 'australia'; SELECT UPPER(@testvalue);
3. DECLARE @testvalue nvarchar(20); SET @testvalue = 'australia'; SELECT REVERSE(@testvalue);
4. All Above

first statement will return the result 'aus' because the first three characters from the left of the string 'australia'.

Show Correct Answer

Source: Microsoft Press book | Asked In: Many Interviews | Alert Moderator