pick(PP_SEQ>0,'') pick(PP_SEQ=0,'')

When

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'))))

Approximate running time: int(P_PLAY_DURATION/60) hours pick(P_PLAY_DURATION % 60>0,'')

Venue

VE_NAME
VE_ADDRESS1
pick(len(VE_ADDRESS2)>0,'') VE_CITY VE_PROVINCE VE_POSTAL_CODE
pick(len(P_SALES_NOTES)>0,'')

Buy To This Event Directions