Q 1 >
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , 11 ,3) as output
1> ‘Microsoft’
2> ‘SQL’
3> BLANK
4> Invalid Substring statement
Answer
Q 2 >
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , 11 ,0) as output
1> ‘Microsoft’
2> ‘SQL’
3> BLANK
4> ‘SQL SERVER’
Answer
Q 3 >
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , -1 ,9) as output
1> ‘Microso’
2> ‘SQL’
3> BLANK
4> ‘SQL SERVER’
Answer
Q 4 >
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , 1 ,9) as output
1> ‘Microsoft’
2> ‘Microsof’
3> BLANK
4> ‘SQL SERVER’
Answer
Q 5 >
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT ‘SQL ‘ + SUBSTRING( @stringtxt , 15 ,6) as output
1> ‘SQL SQL SERVER’
2> ‘SQL SER’
3> BLANK
4> ‘SQL SERVER’
Answer
Q 6 >
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt +‘ SQL’ , 15 ,6) as output
1> ‘SQL SER’
2> ‘SQL SERVER’
3> BLANK
4> ‘SERVER’
Answer
Q 7 >
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , 11 ,Len(@stringtxt)-10) as output
1> ‘Microsoft SQL SERVER’
2> ‘SQL SERVER’
3> ‘Microsoft’
4> Invalid Syntax
Answer
Q 8 >
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , null , null) as output
1> ‘SQL SERVER SQL’
2> ‘SQL SERVER’
3> null
4> ‘Microsoft SQL SERVER’
Answer
Q 9 >
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , 0 ,0) as output
1> ‘Microsoft’
2> ‘SQL’
3> BLANK
4> ‘SQL SERVER’
Answer
Q 10>
DECLARE @stringtxt as varchar(20)
SET @stringtxt=‘Microsoft SQL SERVER’
SELECT SUBSTRING( @stringtxt , null , null) as output
1> ‘SQL SERVER SQL’
2> ‘SQL SERVER’
3> null
4> ‘Microsoft SQL SERVER’
Answer
Also Read..
SQL Interview Q & A Quiz on Select Statement
SQL Interview Q & A Quiz on Create statement