I am trying to find the salesman#'s in FILE A that are not in FILEB which also contains salesman #. The salesman# if FILEA is signed(3,0), the salesman # in FILEB is Char(3). Unfortunately, some of the rows in FILEB contain character values. When I use the following SQL
select * from orinsls a
where ORISNU not in
(select
cast(orslsm as numeric(3,0 )) from orhead where
substring(digits(orcedt),5,2) ||
substring(digits(orcedt),1,4) > '170101' )
I get
Selection error involving field *N
Any ideas how I can ignore the rows that produce the errors or handle the error
select * from orinsls a
where ORISNU not in
(select
cast(orslsm as numeric(3,0 )) from orhead where
substring(digits(orcedt),5,2) ||
substring(digits(orcedt),1,4) > '170101' )
I get
Selection error involving field *N
Any ideas how I can ignore the rows that produce the errors or handle the error
Comment