Re: select offset by alphabetical reference

>> Have a table with Last, First, etc...
>> wish to create a select to grab everything from table whose last name is
>> alphabetically greater than 'Smith'
>>
>> almost like the following (which is obviously incorrect);
>> select last,first from mytable order by last offset 'Smith';
>>
>> ideas on how to handle this at the postgres level rather than
>grabbing all and
>> storing it in an array in PHP/Perl for post processing to grab the desired
>> records?
>
>SELECT last, first FROM mytable WHERE last > 'Smith' ORDER BY last;

Thanks...

has tried that earlier, but mistakenly forgotten to upper case the first S, and
the results I got were obviously less than expected. Some sleep and your
confirmation that I was on the right track led to better results.

Dave