soumenbanerjee
Programmer
Hi,
I have a table where a column is declared as varchar(15). But the value in the column should be an integer of 9 digits only .. i.e from 000000000-999999999. A stored proc is checking whether this column has only acceptable values. If the value present is not an acceptable one i.e if the value is like say, 0000a00X0, then it should update another column with an errorMessage. The above check is to be done within the stored proc. only. Pl. advice how do I do this.
Thanks
I have a table where a column is declared as varchar(15). But the value in the column should be an integer of 9 digits only .. i.e from 000000000-999999999. A stored proc is checking whether this column has only acceptable values. If the value present is not an acceptable one i.e if the value is like say, 0000a00X0, then it should update another column with an errorMessage. The above check is to be done within the stored proc. only. Pl. advice how do I do this.
Thanks