compare date ('01/03/2001) with 'Mar'

[VAX]

Could anyone tell me how can I write the following SQL:

select * from employer
where month(emp_date) = 'Mar'


emp_date in format dd/mm/yyyy

Thank you very much.

[Matthew Solnit]

"VAX" <dunga0@yahoo.com> wrote in message news:3aa453ab$1@news.devx.com...
>
> Could anyone tell me how can I write the following SQL:
>
> select * from employer
> where month(emp_date) = 'Mar'

WHERE DATEPART(month, emp_date) = 3


-- Matthew Solnit