Re: Select statement question - Mailing list pgsql-novice

From denis@coralindia.com
Subject Re: Select statement question
Date
Msg-id 017e01c1c358$994d4180$0232a8c0@coralindia.com
Whole thread Raw
In response to Select statement question  ("ebp" <ebp_register@yahoo.com>)
List pgsql-novice
 
TRy
 
select fname,lname,subscriber_id from kbeg where substr(fname,1,1) ='A'
 
Hope this helps
 
Denis
 
----- Original Message -----
From: ebp
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?
 

pgsql-novice by date:

Previous
From: denis@coralindia.com
Date:
Subject: Re: Duplicates Question
Next
From: Oliver Elphick
Date:
Subject: Re: timestamp value