0

Please login or register to vote for this query.

(click on this box to dismiss)

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 FindSymbol
   ,SUBSTRING('AbCD+efGhI--IIIJAA?Bsdfa!!', 4, 5) as PartOfString4to9
   ,IIF(1=1,'aa','AbCD+efGhI--IIIJAA?Bsdfa!!')
   ,ASCII('
   ')
   ,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

fork query

edited oct 28

created oct 28 anonymous