What will be the output of

Declare @str Varchar(1000) = 'http://www.dotnetfunda.com/articles/show/3158/import-xml-file-and-transform-into-relational-model-for-dynamic-column'
SELECT LEFT(SUBSTRING(@str, PATINDEX('%[0-9]%', @str), LEN(@str)),PATINDEX('%[^0-9]%', SUBSTRING(@str, PATINDEX('%[0-9]%', @str), LEN(@str)) + 'v')-1) ?

 Posted by Rajnilari2015 on 10/24/2015 | Category: Sql Server Interview questions | Views: 1529 | Points: 40
Select from following answers:
  1. 3158
  2. show/3158
  3. show/3158/
  4. http://www.dotnetfunda.com/articles/show/3158
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response