• If you only see nulls in areacode and phonenumber you can get rid of them with temp table like john mentioned

    select into #t1

    from @somedata where AreaCode is not null and PhoneNumber is not null

    Alex S