viewing columns

When I SELECT * from MYTABLE the table isn't very readable because some of the info in the table causes the rows to wrap around to the next line.

Is there a way to make the table more readable?

you could try to split your table by means of a query

example:
table has rows:
UID int, name char(50), counrty char(50)

you can select the different columns as like this:

select UID,name from table_name
or
select name,country from table_name

Thanks,

That's a great solution. Somebody also tipped me off to:

SELECT * FROM mytable G <ENTER>

However, now I'm wondering how to look at each row before it scrolls up the screen.

Anyway, thanks everybody.