Link to home
Start Free TrialLog in
Avatar of Kin Fat SZE
Kin Fat SZEFlag for Hong Kong

asked on

SQL ilas_prov_location field not "TS%" and not "JP%"

(IsTSL ? string.Empty : "Where ilas_prov_location LIKE 'TS%'") +
                (IsJPN ? string.Empty : "Where ilas_prov_location LIKE 'JP%'") +
                (IsJPN || IsTSL ? string.Empty : "What Should I not") +
Untitled.png
Avatar of PortletPaul
PortletPaul
Flag of Australia image
I do not understand the question. If the query below does not meet your expectations please explain in some more detail what you are asking for.

SELECT
      *
FROM prod_type
WHERE ilas_prov_location NOT LIKE 'TS%'
      AND ilas_prov_location NOT LIKE 'JP%'

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial