| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 34953 | 2003-06-28 13:32:00 | writing sql statement | bpt1 (419) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 155960 | 2003-06-28 13:32:00 | I use a school database program (Maze) and want to change a report so that if an address line is vacant, it is left out when printed without leaving a blank space. Any hints or reference to other online help? Thanks |
bpt1 (419) | ||
| 155961 | 2003-06-28 21:33:00 | Something like: where client.address <> "" To not select those with blank address lines. (maybe null or similar if "" doesn't work) robo. |
robo (205) | ||
| 155962 | 2003-06-29 15:32:00 | SELECT table.address, table.city FROM addresstable table WHERE table.address IS NOT NULL; Where table can be any alias addresstable is the name of the table address, city are columns in the table NB: Don't necessarily need alias |
rsnic (3780) | ||
| 1 | |||||