ник: Кабан
может len(nz([URN],""))<>0
я бы так писал
UPDATE (
SELECT ostmp_tblObject.typeError,
ostmp_tblObject.URN
FROM ostmp_tblObject
WHERE len(nz(ostmp_tblObject.URN,""))<>0
) AS s1
SET s1.typeError = "URN IS INVALID"
WHERE checkURN(s1.[URN])=False;
|