Buy Tickets for P_PLAY_TITLE
pick(P_PERFORMANCES=1,'runs from','occurs on') cap(dat(P_SHOW_FIRST,'w n D y')) pick(P_PERFORMANCES=1,con('to ',cap(dat(P_SHOW_LAST,'w n D y'))))
in the
VE_NAME
VE_ADDRESS1
pick(len(VE_ADDRESS2)>0,'') VE_CITY VE_PROVINCE VE_POSTAL_CODE

Approximate running time: P_PLAY_DURATION minutes
D_EVENT Notes
pick(PP_SEQ>0,'') P_SALES_NOTES