Harold and Brent,
Thanks for your help. I tried Brent's solution first, but the MySQL
client didn't seem to like the IF statements.
The case statements worked sweet though.
Cheers guys,
James Katarski
Systems Administrator
School of Computer & Information Science
Edith Cowan
labtimes| 674828 | 674828 |
| oracle | 2213536 | 2213536 |
| passwords | 165264 | 165264 |
| practise| 498296 | 498296 |
| printing| 896432 | 896432 |
| wireless| 933992 | 933992 |
+-+--+--+
Can anyone offer any suggestions as