0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for SharePoint enthusiasts

select ''''
-- Result: '
select len('''')
-- Result: 1

SELECT '''' + ''''
-- Result: ''
SELECT LEN('''' + '''')
-- Result: 2

SELECT '''''' + ''''
-- Result: '''
SELECT LEN('''''' + '''')
-- Result: 3

SELECT 'a' + '''' + ''''
-- Result: a''
SELECT '''' + 'a' + ''''
-- Result: 'a'
SELECT LEN('''' + 'a' + '''')
-- Result: 3

SELECT '' + ''''
-- Result: '
SELECT '''' + ''
-- Result: '
SELECT LEN('''' + '')
-- Result: 1

view current version

edited nov 2

created nov 2 anonymous