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.
| Author |
Topic |
|
artizan
Starting Member
5 Posts |
 Posted - 2008-07-28 : 08:54:26
|
I have used Quiries within MS Access before. Is a query within MS Query the same? ie > greater than, = equal to etc or is these a completely different set of symbols. If this is the case can you direct me to somewhere they are listed.Grateful for any help you can offer.  |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-28 : 09:39:29
|
| The arithmetic operators are same. However there are some difference in functions. Access's NZ is equal to ISNULL() in sql server and IIF(condition, value1, value2) is equal to CASE WHEN condtion value1 else value2 END, etcMadhivananFailing to plan is Planning to fail |
 |
|
|
artizan
Starting Member
5 Posts |
Posted - 2008-07-31 : 05:32:02
|
| RESOVLED THANK YOU |
|
|
|
|
|
|
MS QUERY/MS ACCESS INFORMATION