• Can someone guess without executing what the following SQL will return on Canada like server setup (I have the UK one) 😀

    DECLARE @var varchar(max);

    SET @var = 'Hello World';

    SELECT @var + CHAR(0) + @var

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]