Select statement question

From: "ebp" <ebp_register(at)yahoo(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Select statement question
Date: 2002-03-02 22:13:06
Message-ID: 000d01c1c237$6ec245e0$3601a8c0@chaos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message thiemo 2002-03-02 22:23:10 ERD or UML tool
Previous Message Oliver Elphick 2002-03-01 23:38:19 Re: select into ...outfile