Home Forums SQL Server 2008 SQL Server 2008 - General Detect hex 0x00 in nvarchar column RE: Detect hex 0x00 in nvarchar column

  • July 31, 2012 at 5:58 am

    #1519641

    I did a bit of playing around and couldn't get it to work reliably with LIKE, but this worked ok with CHARINDEX:

    SELECT acolumn FROM #atable WHERE CHARINDEX(NCHAR(0),acolumn)!=0