试试这个：
SELECt myCol FROM myTable WHERe SUBSTRINg(myCol, 1 , 1) >= 'A' AND SUBSTRINg(myCol, 1 , 1) <= 'Z' AND SUBSTRINg(myCol, 2 , 1) >= 'A' AND SUBSTRINg(myCol, 2 , 1) <= 'Z' AND SUBSTRINg(myCol, 3 , 1) >= '0' AND SUBSTRINg(myCol, 3 , 1) <= '9'
试试这个：
SELECt myCol FROM myTable WHERe SUBSTRINg(myCol, 1 , 1) >= 'A' AND SUBSTRINg(myCol, 1 , 1) <= 'Z' AND SUBSTRINg(myCol, 2 , 1) >= 'A' AND SUBSTRINg(myCol, 2 , 1) <= 'Z' AND SUBSTRINg(myCol, 3 , 1) >= '0' AND SUBSTRINg(myCol, 3 , 1) <= '9'
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
