Hi,

I'm sorting a road name table but it seems to be ignoring the spaces
when it's sorting. Why is this and how can I stop it?

Example:

Searching for ILIKE 'MORRIS%' returns

MORRIS AVE
MORRIS DR
MORRIS LA
MORRISON CL
MORRISON CRT
MORRISON DR
MORRISON PL
MORRISON RD
MORRISONS AVE
MORRISON ST
MORRIS RD
MORRIS ST

Any help or advice would be greatly appreciated.

Thanks in advance,

Scott