RECAP Strings

0

Please login or register to vote for this query.

(click on this box to dismiss)

SharePoint

Q&A for SharePoint enthusiasts

SELECT TOP 1
  LEN('AbCD+efGhI--IIIJAA?Bsdfa!!') AS stringlength
  --,UPPER('AbCD+efGhI--IIIJAA?Bsdfa!!') AS uppercase
  --,LOWER('AbCD+efGhI--IIIJAA?Bsdfa!!') AS lowercase
  --,CHARINDEX('-', 'AbCD+efGhI--IIIJAA?Bsdfa!!') AS Position
  ,SUBSTRING('AbCD+efGhI--IIIJAA?Bsdfa!!',4,6) AS removedsubstring
  ,ASCII('\n') AS asciifornewline
  ,CHAR(35) AS symbol35
  ,REPLACE('AbCD+efGhI--IIIJAA?Bsdfa!!','-','') AS replacedcharacter
  ,SUBSTRING
    (
    'AbCD+efGhI--IIIJAA?Bsdfa!!'
    ,CHARINDEX('?', 'AbCD+efGhI--IIIJAA?Bsdfa!!')+1
    ,CHARINDEX('!', 'AbCD+efGhI--IIIJAA?Bsdfa!!')-1
    ) 
   AS removedsubstringbetween
   ,SUBSTRING('AbCD+efGhI--IIIJAA?Bsdfa!!',
      CharIndex('?', 'AbCD+efGhI--IIIJAA?Bsdfa!!')+1,
      CharIndex('!', SUBSTRING('AbCD+efGhI--IIIJAA?Bsdfa!!',
      CharIndex('?', 'AbCD+efGhI--IIIJAA?Bsdfa!!')+1,LEN('AbCD+efGhI--IIIJAA?Bsdfa!!')))-1
   ) as stringBetweenQuestionMarkAndExclamationmark
  ,LTRIM('  AbCD+efGhI--IIIJAA?Bsdfa!!   ') as removedspaces
  ,ISNULL(NULL,'n/a') AS replacednull
FROM Posts

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results