Home Forums SQL Server 2008 SQL Server 2008 - General How to match a UNICODE NULL character within an nVarchar(128) string? RE: How to match a UNICODE NULL character within an nVarchar(128) string?

  • January 17, 2013 at 1:12 pm

    #1578452

    Magoo,

    For the 'AHSGUEST' value, here's what I see:

    select id, name, DATALENGTH(name) as 'thedatalengthName'

    FROM my_user_table

    WHERE id='123'

    123A30

    mtf