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 16, 2013 at 2:21 pm

    #1578032

    something like this can help you identify the actual char;

    i don't know what unicode null is (is that ASCII code(0)?

    but this will help figure it out;

    select

    name,

    N as Position,

    SUBSTRING(name,N,1) As TheChar,

    ASCII(SUBSTRING(name,N,1)) TheAsciiCode

    from users

    CROSS APPLY (SELECT TOP 255 ROW_NUMBER() OVER (ORDER BY (SELECT NULL) -1) AS n

    FROM sys.columns) MiniTally

    WHERE MiniTally.n BETWEEN 0 AND 255

    AND MiniTally.n < LEN(name)

    ORDER BY name,N

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!