Do you have a handout that explains SASIxp Query structure?
	Yes, at the CTAP Conference in Oakland, Molly Schaeffer gave that overview.  Click here for that PowerPoint presentation.
	How do I find students whose parent records (mom and dad) do not have any email address listed?
	T ASTU APRN LastName FirstName PrntGuard if EmailAddr = " " and $count = 2
	How can the first and last name be separated by one space when using query?
	Two data fields can be concatenated in one of the following ways. To concatenate is considered an expression and expressions must be enclosed in braces. * The word CAT or "+++" between two data fields will concatenate those fields. For example, Display ASTU {FirstName CAT LastName} or Display ASTU {FirstName +++ LastName}* Data fields just entered between braces will concatenate also. For example, Display ASTU {FirstName LastName}
	How can I get a list of students with their age, as of today?
	Display ASTU LN FN {Age = (($date - BD)/10000)}
	How do you find a student with an apostrophe in the name?
	Open the atom, in the find mode enter the last name with quotes around it, for example "O'Keefe"
BACK