What is wrong with my syntax? Im trying to pull anything that begins with a J.
sdata/x3/erp/ecommerce/ZBPC?representation=ZBPC.$query&where=upper(BPCNAM)%20like%20%27J%27
the "%25" is Unicode for percent sign
" &where=upper(BPCNAM)%20like%20%27J%25%27 " is the same as " &where=upper(BPCNAM) like 'J%' "