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)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

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 FindMinusSymbol
   ,SUBSTRING('AbCD+efGhI--IIIJAA?Bsdfa!!', 4, 5) as PartOfString4to9
   ,ASCII('
   ') as newLineInAscii
   ,CHAR(35) as symbolOf35Char
   ,REPLACE('AbCD+efGhI--IIIJAA?Bsdfa!!','-','') as replaceAllMinuses
   ,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!!   ') removeSpaces
   ,COALESCE(NULL, 'aaa') NullConversion
FROM Posts

Enter Parameters

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