I have a message error
Invalid int argument data type for substring function argument 1.
I don't understand why!
UPDATE DBO.NUMBER
SET NUMBER = 22675442455
WHERE SUBSTRING(ID,1,2) NOT IN ('67','68')
Invalid type for substring function
Yes
0
Viewed 39
1 Answers
SUBSTRING required first argument as STRING, so simply convert it to VARCHAR.
UPDATE DBO.NUMBER
SET NUMBER = 22675442455
WHERE SUBSTRING(CONVERT(VARCHAR(15),ID)),1,2) NOT IN ('67','68')
Related