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
Replace the where with ---- " &where=upper(BPCNAM)%20like%20%27J%25%27 "
JSeyler What does the %25 mean? and why is there only 1 %25?
JSeyler What does the %25 mean? and why is there only 1 %25?
the "%25" is Unicode for percent sign
" &where=upper(BPCNAM)%20like%20%27J%25%27 " is the same as " &where=upper(BPCNAM) like 'J%' "
*Community Hub is the new name for Sage City