Basic SQL question

[Gregory Kowalski]

Hello,

I'm relatively new at SQL and I am hoping someone can help me with what 
looks like a simple problem.

I have a database where some records contain strings in capital 
letters, and for some reason when I want the query result to appear in 
ascending order, the results in capital letters are out of order.

For example if I have a db with three names:

Paul, PHILIP and Ziggy

the result to the query:

SELECT * FROM table ORDER by name

is

PHILIP
Paul
Ziggy

instead of

Paul
PHILIP
Ziggy

(ascending order)

How can I obtain a query result in truly ascending order when there are 
caps?

Thanks

Greg

PS: the name field is VARCHAR