Hi Randy

if set ANSI is OFF the comparison ends at the end of the shorter string so your empty key is equal to your query value. You could use == or SET ANSI ON to get an exact comparison.

Nick Mason