Queries

The following examples exist for the web version although some may work in the client for the time it is still relevant:

--Sometimes you need to set a value to a blank string ""

--This changes U9 to a space in the client

CHANGE STU U9 TO " "

--Vs

--This changes it to a blank, zero length string in the web

CHANGE STU U9 TO (( '' ))

--Grad Year in a math function that you never have to change (web only)

LIST STU SC ID NM GR (( SUBSTRING(DB_NAME(),4,2) + 2001 + 12 - GR ))

--Gradebook term scores and percent (right column contains DTS of last term specific recalculation most likely caused by teacher intervention and will suffice as a rudimentary last teacher modification timestamp)