Is it a good idea to use null values to distinguish between records?
Based on your comment, I would suggest that the addition of the 'State' column adds additional application complexity (constraints necessary to keep the 'State' column in sync with the value in the 'Name' column) for, what appears to be, no added benefit.