I have a 'person' table with an accountname column and a firstname column. I need to find all person records where accountname does not contain firstname. I cannot use not equal since some part of the account name will contain the firstname. For example: accountname ABC, Inc and firstname ABC would not be returned in the results but ABC, Inc. and Bob would. Any help is appreciated.

I am not 100% sure what you are asking but I think a LIKE will work for you.

SELECT * FROM [Person] WHERE AccountName NOT LIKE '%' + Firstname + '%'

Thanks...that was it. Feel stupid....