$$Excel-Macros$$ Re: anybody knows a bit about SQL?

2009-05-06 Thread Harmeet Singh
Use and operator as: WHERE table.Cal LIKE 2009% AND table.Cal = 'Jan1' I hope that solves the issue. On Wed, May 6, 2009 at 8:13 PM, Yu vincent2...@gmail.com wrote: Hi Dear members, I need to extract some data from Database. For instance, I have such an column in a table. I

$$Excel-Macros$$ Re: anybody knows a bit about SQL?

2009-05-06 Thread Samir Agayev
WHERE table.Cal LIKE 2009% OR table.Cal = 'Jan1' On Wed, May 6, 2009 at 10:17 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Use and operator as: WHERE table.Cal LIKE 2009% AND table.Cal = 'Jan1' I hope that solves the issue. On Wed, May 6, 2009 at 8:13 PM, Yu

$$Excel-Macros$$ Re: anybody knows a bit about SQL?

2009-05-06 Thread ajay anand
SQL Server has a windows based system easy to do there putting selection creteria On Wed, May 6, 2009 at 8:13 PM, Yu vincent2...@gmail.com wrote: Hi Dear members, I need to extract some data from Database. For instance, I have such an column in a table. I wanna extract Jan1 ,Feb2 and