查询订购单号(字符型，长度为4)尾字符是“1”的错误命令是( )。

A．SELECT *FROM 订单 WHERE SUBSTR (订购单号, 4)="1"
B．SELECT *FROM 订单 WHERE SUBSTR (订购单号, 4, 1)="1"
C．SELECT *FROM 订单 WHERE "1" $订购单号
D．SELECT *FROM 订单 WHERE RIGHT (订购单号, 1)="1"