Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 convert datatype to datetype

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-27 : 10:15:37
Amit writes "One of my field is Month where i store April, may,_ _ _ March
no w i have to view reports between 2 months


Query::
select * from table_name where Month between 'April' and 'May'
Month is the field name
when i fire this query it selects value from A of April to M of May
Instead of only April and May
Heard that we have to use convert to do this
help me out

thanx"
   

- Advertisement -