delete from dbo.SSCUKWorkingGLDataloadFile
where SUBSTRING(AccountCode,1,1) = '2' or SUBSTRING(AccountCode,1,1) = '1'
and ClassLoadCode != 'Comp A' or ClassLoadCode != 'Comp T'

quote:

---

Originally posted by rjhe22

hi

im trying to delete info from a table.

im trying to delete records from a table that are not equal to comp a or comp t and where the acc number starts with 1 or 2

i tried the following

delete from dbo.SSCUKWorkingGLDataloadFile
where (SUBSTRING(AccountCode,1,1) = '2' or SUBSTRING(AccountCode,1,1) = '1')
and (ClassLoadCode != 'Comp A' or ClassLoadCode != 'Comp T')

but its deleteing to many out. deletes ones where account number doesnt start with 1 or 2 any ideas why

---

delete from dbo.SSCUKWorkingGLDataloadFile
where (AccountCode like '1%' or AccountCode like '2%')
and ClassLoadCode not in ('Comp A','Comp T')