Re: Select statement question

On Sat, 2 Mar 2002, ebp wrote:

> Im trying to select only the first names from a table that begin with an A.
> I tryed this:
> select fname,lname,subscriber_id from kbeg where fname='A*'||'a*'
> and no rows shows up, im positive that there are atleast 1,000 rows with fname starting with A.
> Any suggestions?
> 
> 

How about something like this

select fname,lname,subscriber_id from kbeg where fname~*'^a';

~ is for regular expression, * is case insensitive, and ^ means at the
beginning of fname.

Look at Chapter 4.10 in Bruce Momjian's "PostgreSQL" for more examples.


-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Doug Silver
Network Manager
Quantified Systems, Inc
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~