How to filter this kind of data ?

[cheeken2u]

My database table consists a Field (Called ApplyDate)store the integer data, like "20061122" represent 22 nov 2006. i need to filter the data for whole November 2006, but if i write SELECT....WHERE ApplyDate = 200611 , it cannot get the data out because the last two digit no specified. So , how i write the SQL Where statement if i want to select Whole Nov 2006 ? (for example, 20061101...20061130 also acceptable)

Best regards, Chee ken

[Anshuman Singh]

why dont you use like command example SELECT....WHERE ApplyDate like '200611%' this will give you proper result

Anshuman Singh [anshumas@rediffmail.com](mailto:Anshuman Singhanshumas@rediffmail.com)

[cheeken2u]

Thanks for your reply. I also have thinking using LIKE , but if the date is 20200611(11 Jun 2020 ), then my data is getting wrong already ! aLthough the date is many years later, but i just thinking have any other way to get the correct data, any idea ? thanks.

Best regards, Chee ken

[Rob Graham]

"Where ApplyDate >= 20061101 and ApplyDate < 20061201"