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

 Posted by Rajkatie on 11/30/2012 | Category: Sql Server Interview questions | Views: 1888 | Points: 40
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

Show Correct Answer


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

Comments or Responses

Login to post response