Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm more familiar with Access and some SQL, but I need to exclude data in a field and having trouble finding the proper syntax.
The data in this field has several sales people, and I want to exclude those that have inactive anywhere in their name.
#1 I'm not sure how to make the not like statement
#2 What represents a wildcard.
where slspsn_no not like '%inactive%'
perfect, thanks
please Jeremy close the discussion