What will be the output of

DECLARE @Name AS VARCHAR(30) ='dotnetfunda!!>$:niceforum'
SELECT NAME = SUBSTRING(@Name,1,ISNULL(NULLIF(PATINDEX('%[^A-Za-z0-9]%',@Name),0)-1,LEN(@Name)))

 Posted by Rajnilari2015 on 10/28/2015 | Category: Sql Server Interview questions | Views: 413 | Points: 40
Select from following answers:
  1. dotnetfunda
  2. niceforum
  3. dotnetfundaniceforum
  4. !!>$:
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response