TRy
select fname,lname,subscriber_id from kbeg where substr(fname,1,1) ='A'
Hope this helps
Denis
----- Original Message -----
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?