I have a table with customer names, last & first are separate columns, In a number of instances, there is a blank space as the first character of the last name.
I'm doing a query like "SELECT * form customer order by lastname, firstname. Of course I get all the ones with blank spaces first.
Is there a function like trim where I can say something like "order by trim(lastname)..."?
Or what is the best way to do this?