SELECT TOP 1 LEN('AbCD+efGhI--IIIJAA?Bsdfa!!') as StringL...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

SELECT TOP 1 
   LEN('AbCD+efGhI--IIIJAA?Bsdfa!!') as StringLength
   ,UPPER('AbCD+efGhI--IIIJAA?Bsdfa!!') as StringUpperCase
   ,LOWER('AbCD+efGhI--IIIJAA?Bsdfa!!') as StringLowerCase
   ,CharIndex('-', 'AbCD+efGhI--IIIJAA?Bsdfa!!') as FindSymbol
   ,SUBSTRING('AbCD+efGhI--IIIJAA?Bsdfa!!', 4, 5) as PartOfString4to9
   ,ASCII('
   ') as newLineInAscii
   ,CHAR(35) 
   ,REPLACE('AbCD+efGhI--IIIJAA?Bsdfa!!','-','')
   ,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
   )
   ,TRIM('AbCD+efGhI--IIIJAA?Bsdfa!!')
   ,COALESCE(NULL, 'aaa')
FROM Posts

Enter Parameters

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