Re: Select statement question

TRy

select fname,lname,subscriber_id from kbeg where substr(fname,1,1) ='A'

Hope this helps

Denis

----- Original Message -----
From: ebp
To: pgsql-novice(at)postgresql(dot)org
Sent: Sunday, March 03, 2002 3:43 AM
Subject: [NOVICE] Select statement question

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?