Finally, you need to know some basic SQL syntax, including signs that let you construct a valid SQL statement. These are some commonly used signs:
Sign |
Means |
Examples |
The value stored in the column matches the value entered to the right of the equal sign. |
circ_privilege = 0 location = “main” |
|
< > |
The value stored in the column matches those less than or greater than the value entered to the right of the less than or greater than sign. |
circ_privilege < 4 borrower# > 150 |
“” |
Quotation marks surround a coded or free text value. |
location = “main” borrower_name = “wilson” |
© 1998-2017 Sirsi Corporation