Combining Several firlds into one.

[Donavon Lerman]

How would I do a Select from several fields into a single field?

<pre>
Here is how the table looks:
+----------+----------+-----------+-----------+
| north | south | east | west |
+----------+----------+-----------+-----------+
| yes | yes | no | no |
+----------+----------+-----------+-----------+
| no | yes | no | yes |
+----------+----------+-----------+-----------+
| no | no | no | yes |
+----------+----------+-----------+-----------+
| yes | no | yes | yes |
+----------+----------+-----------+-----------+

The output should look like:
+---------------------+
| direction |
+---------------------+
| north - south |
+----------+----------+
| south - west |
+----------+----------+
| west |
+----------+----------+
| north - east - west |
+----------+----------+
</pre>