Pedro,

Try

'select name, dtnasc, telephone
from customers
where extract(month from dtnasc)=9
order by dtnasc'

Luiz

----- Original Message -----

From: "psangelotti2" <desenvolvimento@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, September 13, 2004 5:32 PM
Subject: [IBO] Select customers from month of birthday


Hi all,
I am trying to select the customers born in one determined month and
I am not obtaining.
The syntax that I am using is the following one:
select name, dtnasc, telephone
from customers where month(dtnasc) = 9
order by dtnasc
I also tried: where month(dtnasc) = '9' and where month(dtnasc)
= 'AUG'
The objective is to print a list of aniversariantes of the August
month. Somebody would know to help me?
Since already, I am thankful.

Pedro Sergio Angelotti
Pontosoft Informática S/C Ltda.
http://www.pontosoft.com.br/