function FileData_Pairs(x)
{
x.t("statements","default");
x.t("statements","single");
x.t("statements","select");
x.t("statements","expressions");
x.t("statements","flat-file");
x.t("example","min");
x.t("example","shows");
x.t("example","sort");
x.t("example","count");
x.t("example","distinct");
x.t("example","assign");
x.t("example","sum");
x.t("example","resulting");
x.t("example","display");
x.t("example","{01/30/89}");
x.t("example","select");
x.t("example","trim");
x.t("example","number");
x.t("example","max");
x.t("example","salary");
x.t("example","sums");
x.t("example","last_name");
x.t("example","avg");
x.t("example","emp.last_name");
x.t("example","valid");
x.t("example","expression");
x.t("example","following");
x.t("example","returns");
x.t("example","don");
x.t("complex","expressions");
x.t("complex","database");
x.t("complex","column");
x.t("complex","order");
x.t("complex","criteria");
x.t("min","66,89");
x.t("min","minimum");
x.t("min","(salary)");
x.t("min","returns");
x.t("equal","equal");
x.t("equal","sign");
x.t("equal","greater");
x.t("equal","less");
x.t("equal","null");
x.t("equal","matching");
x.t("onrad","space");
x.t("dates","subtract");
x.t("dates","function");
x.t("=any","equivalent");
x.t("combined","form");
x.t("parameter","determines");
x.t("parameter","specifies");
x.t("19900123","iif");
x.t("1992-04-02","03:27:41");
x.t("(0)","returned");
x.t("counted","table");
x.t("$200,000","select");
x.t("$200,000","clause");
x.t("locked","record");
x.t("fetch","next");
x.t("pattern","null");
x.t("pattern","matching");
x.t("right","mattson");
x.t("right","expression");
x.t("right","returns");
x.t("right","decimal");
x.t("01/30/97","dtoc");
x.t("12.346","strval");
x.t("day","part");
x.t("day","week");
x.t("day","{01/30/1989}");
x.t("day","character");
x.t("day","returns");
x.t("lists","select");
x.t("lists","valid");
x.t("meet","retrieved");
x.t("relational","operators");
x.t("relational","operator");
x.t("30000","salary");
x.t("shown","table");
x.t("every","employee");
x.t("[as]","column_alias");
x.t("table","alias");
x.t("table","11-1");
x.t("table","shows");
x.t("table","11-2");
x.t("table","11-3");
x.t("table","left");
x.t("table","11-4");
x.t("table","however");
x.t("table","11-5");
x.t("table","11-6");
x.t("table","emp");
x.t("table","name");
x.t("table","rest");
x.t("table","selected");
x.t("table","aliases");
x.t("table","specification");
x.t("table","intend");
x.t("table","itself");
x.t("table","separated");
x.t("table","names");
x.t("refer","table");
x.t("refer","last_name");
x.t("mm/dd/yyyy","form");
x.t("mm/dd/yyyy","returns");
x.t("$40,000","matter");
x.t("$40,000","hired");
x.t("description","mod");
x.t("description","chr");
x.t("description","date");
x.t("uppercase","upper");
x.t("strval","converts");
x.t("strval","{12/25/1953}");
x.t("strval","woltman");
x.t("strval","returns");
x.t("having","expr1");
x.t("having","sum");
x.t("having","clauses");
x.t("having","clause");
x.t("table1","calc");
x.t("related","example");
x.t("matter","department");
x.t("asterisk","retrieve");
x.t("alias","example");
x.t("alias","table");
x.t("alias","given");
x.t("alias","department");
x.t("abc","ltrim");
x.t("abc","upper");
x.t("abc","trim");
x.t("abc","returns");
x.t("tables","used");
x.t("current","working");
x.t("double","quotation");
x.t("unary","unary");
x.t("unary","plus");
x.t("unary","null");
x.t("{01/23/1990}","returns");
x.t("logon","specified");
x.t("expr1","expr2");
x.t("expr1","rel_operator");
x.t("field","e.last_name");
x.t("field","name");
x.t("field","value");
x.t("field","expression");
x.t("field","values");
x.t("field","names");
x.t("last","year");
x.t("last","name");
x.t("11-1","lists");
x.t("11-1","aggregate");
x.t("until","commit");
x.t("shows","importance");
x.t("shows","examples");
x.t("shows","order");
x.t("line","operators");
x.t("line","evaluated");
x.t("leading","blanks");
x.t("12.3","str");
x.t("statement","form");
x.t("statement","union");
x.t("statement","retrieves");
x.t("statement","supported");
x.t("statement","select");
x.t("statement","number");
x.t("statement","expressions");
x.t("statement","format");
x.t("statement","database");
x.t("statement","joins");
x.t("statement","using");
x.t("statement","returns");
x.t("statement","sql");
x.t("expr2","expr1");
x.t("expr2","field");
x.t("expr2","group");
x.t("expr2","union");
x.t("working","directory");
x.t("11-2","relational");
x.t("11-2","table");
x.t("support","number");
x.t("support","sql_timestamp");
x.t("year","last");
x.t("year","(hire_date)");
x.t("year","part");
x.t("year","select");
x.t("year","{01/30/1989}");
x.t("year","date");
x.t("year","returns");
x.t("today","12/25/1999");
x.t("today","returns");
x.t("200000","union");
x.t("type","select");
x.t("type","last_name");
x.t("type","result");
x.t("type","character");
x.t("type","following");
x.t("change","example");
x.t("change","otherwise");
x.t("11-3","shows");
x.t("11-3","operator");
x.t("evaluates","true");
x.t("non-null","field");
x.t("left","right");
x.t("left","mattson");
x.t("left","outer");
x.t("left","returns");
x.t("time","day");
x.t("time","constants");
x.t("time","returned");
x.t("time","returns");
x.t("11-4","table");
x.t("11-4","functions");
x.t("form","complex");
x.t("form","having");
x.t("form","expr1");
x.t("form","time");
x.t("form","group");
x.t("form","select");
x.t("form","date");
x.t("form","order");
x.t("form","update");
x.t("multiple","column");
x.t("precede","first");
x.t("precede","numeric");
x.t("total","number");
x.t("total","values");
x.t("ascending","(asc)");
x.t("sort","example");
x.t("sort","last_name");
x.t("22000","precede");
x.t("however","cannot");
x.t("regardless","whether");
x.t("bound","member");
x.t("ltrim","abc");
x.t("ltrim","removes");
x.t("11-5","functions");
x.t("10,3","returns");
x.t("dep","emp");
x.t("dep","select");
x.t("dep","department");
x.t("count","field");
x.t("count","distinct");
x.t("count","number");
x.t("count","(name)");
x.t("count","returns");
x.t("comma","expressions");
x.t("comma","following");
x.t("comma","sql");
x.t("default","duplicate");
x.t("default","perform");
x.t("default","returns");
x.t("default","mm/dd/yy");
x.t("lock","held");
x.t("lock","released");
x.t("division","mod");
x.t("division","exponentiation");
x.t("listed","table");
x.t("11-6","functions");
x.t("removes","leading");
x.t("removes","trailing");
x.t("lowercase","lower");
x.t("01/30/1989","returns");
x.t("want","retrieve");
x.t("want","expression");
x.t("details","example");
x.t("details","column_alias");
x.t("details","following");
x.t("emp","distinct");
x.t("emp","emp");
x.t("emp","group");
x.t("emp","union");
x.t("emp","dept");
x.t("emp","aggregate");
x.t("emp","month");
x.t("emp","may");
x.t("emp","different");
x.t("emp","salary");
x.t("emp","e.mgr_id");
x.t("emp","separate");
x.t("emp","date");
x.t("emp","order");
x.t("distinct","last");
x.t("distinct","dep");
x.t("distinct","last_name");
x.t("distinct","department");
x.t("distinct","operator");
x.t("single","double");
x.t("single","quotation");
x.t("single","value");
x.t("single","result");
x.t("retrieved","clause");
x.t("new","date");
x.t("precedence","precedence");
x.t("precedence","expressions");
x.t("precedence","salary");
x.t("precedence","operator");
x.t("access","foxpro");
x.t("foxpro","3.0");
x.t("e.last_name","table");
x.t("e.last_name","alias");
x.t("includes","non-matching");
x.t("includes","matching");
x.t("price","1.05");
x.t("12.34567,6,3","returns");
x.t("dayofweek","{05/01/1995}");
x.t("dayofweek","returns");
x.t("(6.4321)","returns");
x.t("list","field");
x.t("list","shows");
x.t("list","column");
x.t("indicates","tables");
x.t("indicates","rows");
x.t("combines","results");
x.t("braces","example");
x.t("upper","bound");
x.t("upper","allen");
x.t("upper","changes");
x.t("determines","format");
x.t("group","column_expressions");
x.t("group","column_expression");
x.t("group","clause");
x.t("group","dept_id");
x.t("assign","alias");
x.t("sum","total");
x.t("sum","salaries");
x.t("sum","salary");
x.t("sum","(salary)");
x.t("complete","path");
x.t("t2.key","clause");
x.t("add","number");
x.t("substring","string");
x.t("3.0","driver");
x.t("66,89","returns");
x.t("simple","table");
x.t("simple","field");
x.t("results","joining");
x.t("results","two");
x.t("20000","example");
x.t("20000","group");
x.t("20000","big");
x.t("20000","salary");
x.t("20000","returns");
x.t("20000","update");
x.t("assume","salary");
x.t("according","type");
x.t("yyyymmdd","dtos");
x.t("applies","flat-file");
x.t("(7,2)","returns");
x.t("(hire_date)","year");
x.t("duplicate","rows");
x.t("duplicate","values");
x.t("false","time");
x.t("false","parameters");
x.t("false","value");
x.t("false","portability");
x.t("become","complex");
x.t("len","abc");
x.t("len","returns");
x.t("commas","example");
x.t("specified","values");
x.t("specified","order");
x.t("specified","connect");
x.t("specified","slash");
x.t("locks","rows");
x.t("true","false");
x.t("true","function");
x.t("true","value");
x.t("true","subquery");
x.t("converts","ascii");
x.t("converts","number");
x.t("converts","value");
x.t("converts","character");
x.t("converts","date");
x.t("converts","timestamp");
x.t("iif","salary");
x.t("iif","returns");
x.t("mod","10,3");
x.t("mod","divides");
x.t("union","form");
x.t("union","select");
x.t("union","[all]");
x.t("union","operator");
x.t("name","example");
x.t("name","alias");
x.t("name","count");
x.t("name","combine");
x.t("name","pay");
x.t("name","expression");
x.t("name","values");
x.t("name","used");
x.t("path","names");
x.t("common","expression");
x.t("enclosed","double");
x.t("enclosed","single");
x.t("resulting","value");
x.t("range","values");
x.t("dept","d101");
x.t("suitable","format");
x.t("dateval","01/30/1989");
x.t("dateval","converts");
x.t("enables","specify");
x.t("follows","field");
x.t("mattson","returns");
x.t("dtoc","converts");
x.t("dtoc","{01/30/1997}");
x.t("123.46","round");
x.t("eliminates","duplicate");
x.t("aggregate","functions");
x.t("aggregate","expression");
x.t("aggregate","values");
x.t("aggregate","used");
x.t("aggregate","returns");
x.t("part","select");
x.t("part","number");
x.t("part","date");
x.t("average","salary");
x.t("average","values");
x.t("raises","example");
x.t("raises","number");
x.t("raises","order");
x.t("perform","ascending");
x.t("(asc)","sort");
x.t("plus","minus");
x.t("subtract","number");
x.t("exists","true");
x.t("exists","following");
x.t("tson","substr");
x.t("parameters","string");
x.t("parameters","logical");
x.t("parameters","number");
x.t("none","default");
x.t("zero","(0)");
x.t("manipulation","example");
x.t("manipulation","operators");
x.t("sign","includes");
x.t("combine","field");
x.t("constants","braces");
x.t("constants","true");
x.t("constants","constants");
x.t("constants","pairs");
x.t("constants","hh:mm:ss");
x.t("constants","exponential");
x.t("constants","values");
x.t("constants","mm/dd/yy");
x.t("ascii","code");
x.t("rest","select");
x.t("$20,000","record");
x.t("$20,000","select");
x.t("concatenation","moving");
x.t("concatenation","keeping");
x.t("strings","function");
x.t("strings","expression");
x.t("month","(hire_date)");
x.t("month","part");
x.t("month","{01/30/1989}");
x.t("month","returns");
x.t("fields","select");
x.t("fields","returned");
x.t("string","right");
x.t("string","uppercase");
x.t("string","strval");
x.t("string","left");
x.t("string","ltrim");
x.t("string","lowercase");
x.t("string","default");
x.t("string","len");
x.t("string","parameters");
x.t("string","manipulation");
x.t("string","blanks");
x.t("string","9:49");
x.t("string","trim");
x.t("string","first");
x.t("string","number");
x.t("string","chr");
x.t("string","returned");
x.t("string","valid");
x.t("string","rtrim");
x.t("string","optional");
x.t("string","date");
x.t("string","using");
x.t("prefixed","table");
x.t("record","select");
x.t("record","fetched");
x.t("record","compares");
x.t("record","updated");
x.t("pairs","single");
x.t("col1","3.4e");
x.t("blanks","shown");
x.t("blanks","want");
x.t("blanks","concatenation");
x.t("blanks","string");
x.t("blanks","trim");
x.t("blanks","space");
x.t("blanks","end");
x.t("{01/01/1990}","hire_date");
x.t("third","parameter");
x.t("12.34567,4,1","returns");
x.t("empty","string");
x.t("int","(6.4321)");
x.t("int","returns");
x.t("column_expressions","list");
x.t("column_expressions","column_expressions");
x.t("column_expressions","match");
x.t("second","example");
x.t("second","parameter");
x.t("second","line");
x.t("second","column");
x.t("quotation","marks");
x.t("quotation","mark");
x.t("col2","numeric");
x.t("addition","subtraction");
x.t("minus","example");
x.t("moving","trailing");
x.t("rely","driver");
x.t("characters","string");
x.t("characters","including");
x.t("characters","extract");
x.t("yyyy/mm/dd","optional");
x.t("9:49","time");
x.t("week","(1-7)");
x.t("round","rounds");
x.t("round","123.456");
x.t("functions","table");
x.t("functions","aggregate");
x.t("functions","part");
x.t("functions","constants");
x.t("functions","retrieve");
x.t("functions","may");
x.t("functions","grouped");
x.t("functions","return");
x.t("functions","flat-file");
x.t("retrieves","employees");
x.t("retrieves","names");
x.t("selected","select");
x.t("enclose","character");
x.t("enclose","date");
x.t("enclose","conditions");
x.t("present","related");
x.t("small","str");
x.t("small","returns");
x.t("supported","flat-file");
x.t("mathematical","operations");
x.t("display","departments");
x.t("queries","common");
x.t("multiplication","division");
x.t("equivalent","compares");
x.t("leftmost","characters");
x.t("mat","right");
x.t("point","str");
x.t("point","optionally");
x.t("12/25/1953","strval");
x.t("drivers","support");
x.t("drivers","empty");
x.t("drivers","select");
x.t("drivers","return");
x.t("give","column");
x.t("outer","join");
x.t("non-matching","rows");
x.t("next","record");
x.t("operators","relational");
x.t("operators","line");
x.t("operators","form");
x.t("operators","functions");
x.t("operators","logical");
x.t("operators","first");
x.t("operators","salary");
x.t("operators","include");
x.t("operators","character");
x.t("operators","date");
x.t("operators","two");
x.t("operators","numeric");
x.t("operators","separating");
x.t("operators","evaluated");
x.t("operators","operator");
x.t("logical","constants");
x.t("logical","operators");
x.t("logical","expression");
x.t("logical","operator");
x.t("{01/30/89}","{12:35:10}");
x.t("keeping","trailing");
x.t("substr","conrad");
x.t("substr","returns");
x.t("conrad","2,3");
x.t("conrad","returns");
x.t("select","statements");
x.t("select","lists");
x.t("select","statement");
x.t("select","left");
x.t("select","dep");
x.t("select","distinct");
x.t("select","emp");
x.t("select","list");
x.t("select","name");
x.t("select","col1");
x.t("select","first_name");
x.t("select","salary");
x.t("select","[distinct]");
x.t("select","last_name");
x.t("select","emp_id");
x.t("select","order");
x.t("select","clause");
x.t("select","dept_id");
x.t("first","example");
x.t("first","table");
x.t("first","line");
x.t("first","second");
x.t("first","query");
x.t("first","character");
x.t("first","column");
x.t("preceded","distinct");
x.t("minimum","salary");
x.t("minimum","value");
x.t("t1.key","t2.key");
x.t("1.1","22000");
x.t("1.1","-22000");
x.t("trim","abc");
x.t("trim","removes");
x.t("trim","function");
x.t("trim","(first_name)");
x.t("trim","(last_name)");
x.t("allen","left");
x.t("allen","lower");
x.t("allen","returns");
x.t("space","(5)");
x.t("space","generates");
x.t("smaller","two");
x.t("number","non-null");
x.t("number","total");
x.t("number","name");
x.t("number","zero");
x.t("number","int");
x.t("number","characters");
x.t("number","round");
x.t("number","functions");
x.t("number","rows");
x.t("number","power");
x.t("number","digits");
x.t("number","output");
x.t("number","values");
x.t("number","character");
x.t("number","column");
x.t("number","123");
x.t("number","date");
x.t("number","days");
x.t("10000","30000");
x.t("10000","20000");
x.t("retrieve","asterisk");
x.t("retrieve","fields");
x.t("retrieve","employees");
x.t("max","66,89");
x.t("max","maximum");
x.t("max","(salary)");
x.t("max","returns");
x.t("maximum","salary");
x.t("maximum","value");
x.t("aliases","used");
x.t("function","description");
x.t("function","applies");
x.t("function","concatenating");
x.t("function","returns");
x.t("{12/25/1953}","returns");
x.t("yyyymmddhhmmss","returned");
x.t("indexing","ttoc");
x.t("length","string");
x.t("expressions","table");
x.t("expressions","unary");
x.t("expressions","listed");
x.t("expressions","want");
x.t("expressions","details");
x.t("expressions","become");
x.t("expressions","commas");
x.t("expressions","select");
x.t("expressions","may");
x.t("expressions","expressions");
x.t("expressions","different");
x.t("expressions","match");
x.t("expressions","enable");
x.t("expressions","include");
x.t("expressions","data");
x.t("expressions","positioned");
x.t("expressions","examples");
x.t("expressions","column");
x.t("expressions","order");
x.t("expressions","separated");
x.t("expressions","used");
x.t("expressions","evaluated");
x.t("expressions","sql");
x.t("expressions","operator");
x.t("expressions","rel_operator");
x.t("may","combined");
x.t("may","refer");
x.t("may","prefixed");
x.t("may","expressions");
x.t("may","include");
x.t("combination","complex");
x.t("specifies","format");
x.t("specifies","date");
x.t("specifies","names");
x.t("specifies","conditions");
x.t("departments","salaries");
x.t("departments","whose");
x.t("person","example");
x.t("different","salary");
x.t("different","data");
x.t("different","order");
x.t("cannot","rely");
x.t("whether","drivers");
x.t("first_name","emp");
x.t("first_name","select");
x.t("first_name","salary");
x.t("first_name","last_name");
x.t("first_name","hire_date");
x.t("first_name","either");
x.t("first_name","robert");
x.t("salaries","totaling");
x.t("salaries","greater");
x.t("salaries","department");
x.t("salaries","employees");
x.t("row","distinct");
x.t("row","contains");
x.t("hh:mm:ss","logical");
x.t("hh:mm:ss","returned");
x.t("{12/25/1999}","today");
x.t("{12/25/1999}","dateval");
x.t("format","yyyymmdd");
x.t("format","indexing");
x.t("format","result");
x.t("format","character");
x.t("format","clause");
x.t("directory","complete");
x.t("returned","table");
x.t("returned","suitable");
x.t("returned","yyyymmddhhmmss");
x.t("returned","rows");
x.t("returned","return");
x.t("returned","least");
x.t("returned","subquery");
x.t("returned","values");
x.t("returned","val");
x.t("returned","numval");
x.t("returned","flat-file");
x.t("match","column");
x.t("keyword","union");
x.t("types","specified");
x.t("types","column");
x.t("held","until");
x.t("(first_name)","trim");
x.t("50000","last_name");
x.t("chr","converts");
x.t("chr","(67)");
x.t("changes","letter");
x.t("rightmost","characters");
x.t("simply","field");
x.t("grouped","according");
x.t("grouped","clause");
x.t("marks","together");
x.t("marks","include");
x.t("marks","two");
x.t("works","regardless");
x.t("prefaced","=any");
x.t("prefaced","following");
x.t("important","table");
x.t("yy/mm/dd","ctod");
x.t("yy/mm/dd","returns");
x.t("dtos","{01/23/1990}");
x.t("dtos","converts");
x.t("big","small");
x.t("big","salary");
x.t("ttoc","1992-04-02");
x.t("ttoc","note");
x.t("follow","select");
x.t("rows","example");
x.t("rows","meet");
x.t("rows","results");
x.t("rows","aggregate");
x.t("rows","first");
x.t("rows","select");
x.t("rows","returned");
x.t("rows","keyword");
x.t("rows","sorted");
x.t("rows","database");
x.t("rows","null");
x.t("rows","result");
x.t("rows","employee");
x.t("rows","including");
x.t("enable","mathematical");
x.t("end","following");
x.t("jones","first_name");
x.t("code","one-character");
x.t("salary","field");
x.t("salary","emp");
x.t("salary","20000");
x.t("salary","1.1");
x.t("salary","select");
x.t("salary","10000");
x.t("salary","greater");
x.t("salary","null");
x.t("salary","last_name");
x.t("salary","hire_date");
x.t("salary","1.05");
x.t("salary","1.07");
x.t("salary","40000");
x.t("salary","sql");
x.t("salary","commission");
x.t("return","dates");
x.t("return","table");
x.t("return","single");
x.t("return","duplicate");
x.t("return","aggregate");
x.t("return","blanks");
x.t("return","character");
x.t("return","numbers");
x.t("return","trailing");
x.t("sums","salaries");
x.t("groups","rows");
x.t("{12:35:10}","form");
x.t("hire","date");
x.t("one-character","string");
x.t("{05/01/1995}","returns");
x.t("database","table");
x.t("database","field");
x.t("database","queries");
x.t("database","salary");
x.t("given","table");
x.t("e.mgr_id","f.emp_id");
x.t("least","$20,000");
x.t("least","record");
x.t("least","days");
x.t("sorted","form");
x.t("exponentiation","exponentiation");
x.t("exponentiation","following");
x.t("lower","upper");
x.t("lower","allen");
x.t("lower","changes");
x.t("03:27:41","ttoc");
x.t("03:27:41","returns");
x.t("100","numval");
x.t("[distinct]","column_expression");
x.t("totaling","$200,000");
x.t("whose","sums");
x.t("greater","equal");
x.t("greater","$200,000");
x.t("greater","20000");
x.t("greater","greater");
x.t("together","example");
x.t("january","year");
x.t("january","1989");
x.t("parentheses","enclose");
x.t("(67)","returns");
x.t("30/01/97","dtoc");
x.t("table_names","simple");
x.t("table_names","table_alias");
x.t("null","equal");
x.t("null","range");
x.t("null","exists");
x.t("null","salary");
x.t("null","null");
x.t("null","values");
x.t("less","equal");
x.t("less","less");
x.t("(optional)","substr");
x.t("last_name","complex");
x.t("last_name","example");
x.t("last_name","field");
x.t("last_name","emp");
x.t("last_name","raises");
x.t("last_name","second");
x.t("last_name","first_name");
x.t("last_name","jones");
x.t("last_name","salary");
x.t("last_name","robertjones");
x.t("last_name","robert");
x.t("last_name","update");
x.t("include","single");
x.t("include","enclose");
x.t("include","mathematical");
x.t("include","exponential");
x.t("include","following");
x.t("{01/20/1990}","relational");
x.t("hired","january");
x.t("19920402032741","username");
x.t("username","btrieve");
x.t("divides","two");
x.t("[all]","select");
x.t("hire_date","field");
x.t("hire_date","emp");
x.t("hire_date","{01/01/1990}");
x.t("hire_date","retrieve");
x.t("hire_date","{01/20/1990}");
x.t("hire_date","{01/30/1989}");
x.t("hire_date","{01/30/1990}");
x.t("hire_date","{02/04/1990}");
x.t("value","min");
x.t("value","field");
x.t("value","type");
x.t("value","false");
x.t("value","iif");
x.t("value","$20,000");
x.t("value","logical");
x.t("value","first_name");
x.t("value","returned");
x.t("value","rows");
x.t("value","salary");
x.t("value","hire_date");
x.t("value","value");
x.t("value","1.05");
x.t("value","otherwise");
x.t("value","clause");
x.t("(last_name)","date");
x.t("{01/30/1989}","dept");
x.t("{01/30/1989}","salary");
x.t("{01/30/1989}","ctod");
x.t("{01/30/1989}","returns");
x.t("power","pow");
x.t("avg","average");
x.t("avg","salary");
x.t("avg","(salary)");
x.t("constant","enclosed");
x.t("constant","enclose");
x.t("constant","values");
x.t("already","defined");
x.t("pay","birth_date");
x.t("emp_id","last_name");
x.t("3.4e","table1");
x.t("concatenating","strings");
x.t("importance","precedence");
x.t("sorts","last_name");
x.t("fetched","locked");
x.t("calc","3.4e-6");
x.t("1989","every");
x.t("1989","functions");
x.t("1989","max");
x.t("making","$40,000");
x.t("force","clause");
x.t("onr","substr");
x.t("sql_timestamp","btrieve");
x.t("1.05","value");
x.t("1.05","constant");
x.t("1.05","sql");
x.t("department","having");
x.t("department","emp");
x.t("department","sum");
x.t("department","select");
x.t("department","row");
x.t("department","hire");
x.t("department","column");
x.t("department","d101");
x.t("emp.last_name","e.last_name");
x.t("expression","example");
x.t("expression","table");
x.t("expression","field");
x.t("expression","evaluates");
x.t("expression","default");
x.t("expression","price");
x.t("expression","dayofweek");
x.t("expression","simple");
x.t("expression","true");
x.t("expression","preceded");
x.t("expression","select");
x.t("expression","works");
x.t("expression","portable");
x.t("expression","order");
x.t("expression","used");
x.t("expression","following");
x.t("expression","elements");
x.t("expression","operator");
x.t("valid","aggregate");
x.t("valid","number");
x.t("valid","already");
x.t("valid","expression");
x.t("valid","data");
x.t("clauses","having");
x.t("clauses","order");
x.t("clauses","sql");
x.t("notation","include");
x.t("notation","expression");
x.t("notation","numeric");
x.t("subquery","exists");
x.t("subquery","returned");
x.t("subquery","prefaced");
x.t("digits","right");
x.t("separate","multiple");
x.t("2,3","second");
x.t("2,3","returns");
x.t("str","12.34567,6,3");
x.t("str","converts");
x.t("str","12.34567,4,1");
x.t("str","12.34567,4");
x.t("output","characters");
x.t("larger","two");
x.t("today\u2019s","date");
x.t("query","example");
x.t("query","retrieves");
x.t("1.07","column");
x.t("joining","table");
x.t("data","type");
x.t("data","types");
x.t("data","trailing");
x.t("positioned","number");
x.t("subtraction","multiplication");
x.t("becomes","important");
x.t("rtrim","abc");
x.t("rtrim","removes");
x.t("optional","third");
x.t("optional","second");
x.t("woltman","strval");
x.t("woltman","returns");
x.t("pow","(7,2)");
x.t("pow","raises");
x.t("sort_expression","field");
x.t("sort_expression","desc");
x.t("desc","asc");
x.t("result","default");
x.t("result","single");
x.t("result","none");
x.t("result","returned");
x.t("result","return");
x.t("result","query");
x.t("defined","group");
x.t("exponential","notation");
x.t("meaning","equal");
x.t("meaning","example");
x.t("meaning","add");
x.t("meaning","concatenation");
x.t("meaning","addition");
x.t("examples","relational");
x.t("examples","assume");
x.t("examples","number");
x.t("examples","last_name");
x.t("examples","hire_date");
x.t("examples","character");
x.t("examples","date");
x.t("examples","numeric");
x.t("values","counted");
x.t("values","field");
x.t("values","change");
x.t("values","count");
x.t("values","true");
x.t("values","aggregate");
x.t("values","max");
x.t("values","expressions");
x.t("values","grouped");
x.t("values","lower");
x.t("values","avg");
x.t("values","numeric");
x.t("values","special");
x.t("values","following");
x.t("values","using");
x.t("values","member");
x.t("join","includes");
x.t("join","t1.key");
x.t("employee","database");
x.t("employee","making");
x.t("40000","dept");
x.t("40000","hire_date");
x.t("40000","exempt");
x.t("letter","string");
x.t("column_expression","[as]");
x.t("column_expression","having");
x.t("column_expression","select");
x.t("column_expression","simply");
x.t("column_expression","table_names");
x.t("table_alias","expr1");
x.t("table_alias","name");
x.t("table_alias","table_names");
x.t("specification","emp");
x.t("character","specified");
x.t("character","constants");
x.t("character","strings");
x.t("character","string");
x.t("character","operators");
x.t("character","expressions");
x.t("character","constant");
x.t("character","data");
x.t("character","extract");
x.t("3.4e-6","col2");
x.t("portable","example");
x.t("{30/01/1989}","following");
x.t("column","dep");
x.t("column","expressions");
x.t("column","expression");
x.t("column","descriptive");
x.t("two","dates");
x.t("two","double");
x.t("two","single");
x.t("two","select");
x.t("two","expressions");
x.t("two","values");
x.t("two","numbers");
x.t("two","conditions");
x.t("intend","update");
x.t("otherwise","lock");
x.t("otherwise","returns");
x.t("date","day");
x.t("date","year");
x.t("date","today");
x.t("date","time");
x.t("date","dateval");
x.t("date","manipulation");
x.t("date","constants");
x.t("date","month");
x.t("date","functions");
x.t("date","operators");
x.t("date","number");
x.t("date","expressions");
x.t("date","hire_date");
x.t("date","force");
x.t("date","expression");
x.t("date","optional");
x.t("date","character");
x.t("date","following");
x.t("date","separator");
x.t("date","returns");
x.t("date","produce");
x.t("note","function");
x.t("note","flat-file");
x.t("dd/mm/yy","returns");
x.t("97-01-30","dtos");
x.t("(1-7)","date");
x.t("integer","part");
x.t("123","table");
x.t("123","round");
x.t("123","val");
x.t("123","returns");
x.t("column_alias","column_expression");
x.t("column_alias","used");
x.t("numeric","field");
x.t("numeric","operators");
x.t("numeric","expressions");
x.t("joins","table");
x.t("itself","example");
x.t("employees","least");
x.t("employees","hired");
x.t("employees","department");
x.t("employees","company");
x.t("mark","character");
x.t("portability","exponential");
x.t("optionally","number");
x.t("val","converts");
x.t("val","123");
x.t("today's","date");
x.t("order","example");
x.t("order","operators");
x.t("order","expressions");
x.t("order","parentheses");
x.t("order","last_name");
x.t("order","sorts");
x.t("order","clauses");
x.t("order","2,3");
x.t("order","data");
x.t("order","sort_expression");
x.t("order","clause");
x.t("reverse","meaning");
x.t("21:49:00","ttoc");
x.t("timestamp","character");
x.t("numbers","min");
x.t("numbers","function");
x.t("numbers","max");
x.t("numbers","returns");
x.t("12/25/1999","today");
x.t("12/25/1999","date");
x.t("clause","having");
x.t("clause","indicates");
x.t("clause","group");
x.t("clause","locks");
x.t("clause","enables");
x.t("clause","aggregate");
x.t("clause","specifies");
x.t("clause","follow");
x.t("clause","table_names");
x.t("clause","valid");
x.t("clause","column");
x.t("clause","order");
x.t("clause","clause");
x.t("clause","used");
x.t("clause","following");
x.t("clause","evaluated");
x.t("clause","rel_operator");
x.t("clause","contains");
x.t("clause","update");
x.t("used","refer");
x.t("used","field");
x.t("used","dtoc");
x.t("used","give");
x.t("used","select");
x.t("used","return");
x.t("used","clauses");
x.t("used","reverse");
x.t("(salary)","200000");
x.t("(salary)","emp");
x.t("(salary)","combination");
x.t("(salary)","returns");
x.t("special","example");
x.t("links","two");
x.t("following","example");
x.t("following","table");
x.t("following","form");
x.t("following","list");
x.t("following","operators");
x.t("following","select");
x.t("following","examples");
x.t("separated","comma");
x.t("dept_id","having");
x.t("dept_id","statement");
x.t("dept_id","sum");
x.t("either","$40,000");
x.t("either","following");
x.t("elements","example");
x.t("elements","follows");
x.t("elements","valid");
x.t("{01/30/1990}","example");
x.t("separator","character");
x.t("(name)","returns");
x.t("using","count");
x.t("using","union");
x.t("using","format");
x.t("f.emp_id","equal");
x.t("similarly","constant");
x.t("separating","two");
x.t("compares","value");
x.t("(5)","returns");
x.t("connect","time");
x.t("ctod","01/30/1989");
x.t("ctod","converts");
x.t("asc","sort_expression");
x.t("asc","update");
x.t("returns","onrad");
x.t("returns","min");
x.t("returns","19900123");
x.t("returns","01/30/97");
x.t("returns","12.346");
x.t("returns","day");
x.t("returns","mm/dd/yyyy");
x.t("returns","strval");
x.t("returns","abc");
x.t("returns","12.3");
x.t("returns","year");
x.t("returns","time");
x.t("returns","dayofweek");
x.t("returns","sum");
x.t("returns","substring");
x.t("returns","false");
x.t("returns","len");
x.t("returns","true");
x.t("returns","dtoc");
x.t("returns","123.46");
x.t("returns","average");
x.t("returns","tson");
x.t("returns","month");
x.t("returns","int");
x.t("returns","yyyy/mm/dd");
x.t("returns","round");
x.t("returns","small");
x.t("returns","leftmost");
x.t("returns","mat");
x.t("returns","12/25/1953");
x.t("returns","minimum");
x.t("returns","allen");
x.t("returns","smaller");
x.t("returns","number");
x.t("returns","maximum");
x.t("returns","length");
x.t("returns","departments");
x.t("returns","row");
x.t("returns","{12/25/1999}");
x.t("returns","rightmost");
x.t("returns","yy/mm/dd");
x.t("returns","big");
x.t("returns","rows");
x.t("returns","100");
x.t("returns","30/01/97");
x.t("returns","19920402032741");
x.t("returns","{01/30/1989}");
x.t("returns","onr");
x.t("returns","1989");
x.t("returns","str");
x.t("returns","larger");
x.t("returns","today\u2019s");
x.t("returns","rtrim");
x.t("returns","woltman");
x.t("returns","pow");
x.t("returns","{30/01/1989}");
x.t("returns","dd/mm/yy");
x.t("returns","97-01-30");
x.t("returns","two");
x.t("returns","integer");
x.t("returns","123");
x.t("returns","today's");
x.t("returns","21:49:00");
x.t("returns","remainder");
x.t("returns","dd/mm/yyyy");
x.t("returns","mm/dd/yy");
x.t("returns","04/02/92");
x.t("deleted","lock");
x.t("{02/04/1990}","hire_date");
x.t("criteria","two");
x.t("exempt","logical");
x.t("exempt","operator");
x.t("evaluated","left");
x.t("evaluated","operators");
x.t("evaluated","first");
x.t("evaluated","different");
x.t("evaluated","becomes");
x.t("decimal","point");
x.t("dbase","access");
x.t("remainder","division");
x.t("numval","converts");
x.t("numval","123");
x.t("company","least");
x.t("sql","statements");
x.t("sql","select");
x.t("sql","expressions");
x.t("flat-file","drivers");
x.t("operations","string");
x.t("operations","character");
x.t("names","current");
x.t("names","constants");
x.t("names","prefixed");
x.t("names","fields");
x.t("names","may");
x.t("names","expressions");
x.t("names","database");
x.t("names","constant");
x.t("names","table_alias");
x.t("names","employees");
x.t("operator","unary");
x.t("operator","precede");
x.t("operator","distinct");
x.t("operator","precedence");
x.t("operator","combines");
x.t("operator","union");
x.t("operator","eliminates");
x.t("operator","select");
x.t("operator","meaning");
x.t("operator","links");
x.t("operator","used");
x.t("driver","converts");
x.t("driver","return");
x.t("driver","dbase");
x.t("member","specified");
x.t("member","subquery");
x.t("dd/mm/yyyy","returns");
x.t("{01/30/1997}","returns");
x.t("including","rows");
x.t("including","decimal");
x.t("commit","change");
x.t("released","fetch");
x.t("don","similarly");
x.t("-22000","character");
x.t("robertjones","note");
x.t("days","select");
x.t("days","date");
x.t("days","two");
x.t("commission","50000");
x.t("btrieve","logon");
x.t("btrieve","driver");
x.t("rel_operator","relational");
x.t("rel_operator","expr2");
x.t("descriptive","name");
x.t("conditions","form");
x.t("conditions","present");
x.t("conditions","may");
x.t("conditions","rows");
x.t("conditions","groups");
x.t("conditions","evaluated");
x.t("birth_date","person");
x.t("mm/dd/yy","mm/dd/yyyy");
x.t("mm/dd/yy","hh:mm:ss");
x.t("mm/dd/yy","returns");
x.t("trailing","blanks");
x.t("robert","example");
x.t("robert","jones");
x.t("produce","new");
x.t("d101","retrieves");
x.t("d101","logical");
x.t("d101","salary");
x.t("d101","hired");
x.t("d101","hire_date");
x.t("d101","either");
x.t("d101","evaluated");
x.t("generates","string");
x.t("12.34567,4","returns");
x.t("update","column_expressions");
x.t("update","last_name");
x.t("update","column_expression");
x.t("update","clause");
x.t("update","separated");
x.t("matching","pattern");
x.t("matching","rows");
x.t("contains","department");
x.t("contains","conditions");
x.t("specify","conditions");
x.t("updated","deleted");
x.t("extract","number");
x.t("extract","(optional)");
x.t("slash","used");
x.t("04/02/92","03:27:41");
x.t("rounds","number");
x.t("123.456","returns");
}