--有多少字段加多少个 Is Not NullSelect * From YourTable Where CST_NO Is Not Null And CST_NM Is Not Null And ACCT_NO1 Is Not Null And CURR1 Is Not Null And ACCT_NO2 Is Not Null And CURR2 Is Not Null And ACCT_NO3 Is Not Null