statusfk is supposed to be null or have an int value that is 8 numbers. but i saw in the table there is one with 7 digits.
but the following query
select * from tblsinger where len(statusfk) not in (8, null)
did not bring back the records for statusfk with 7 length.
what is wrong with the query?