Posts By Category

Posts By Date

Resources:

C# Books
ASP.NET Books DotNet4All

If you like to support this site, feel free to make a donation to support improvements.

Thank you!

Monetize Your Blog

Including IIF statement in SQL query for MS Access and using Is Null

Writing SQL query for MS Access

Posted on 5/23/2007 @ 5:01 AM in #SQL | 0 comments

I'm currently organizing an MS Access database and setting up some SQL queries that export data into CSV files for Yahoo Store. One of the things I had to do was to create fields in the CSV file that are compound of other existing fields in the database, and some that even depended on the existence of other physical fields in the Access database.

Continued...

SQL Select LIKE statement in MS Access needs * instead of %

Wild card % does not work in MS Access for LIKE SQL statement

Posted on 5/16/2007 @ 4:13 PM in #SQL | 5 comments

Using LIKE statement in an SQL query requires specifying wild cards in the search pattern. In C# .NET, the wild card is %, however if you are building your SQL query directly from MS Access, I found out you need to use the asterisk (*) instead of (%) wild card to achieve the same result.

Continued...

Copyright © 2007 Yousef Mannaa. All material on this site is copyrighted.
Do not publish or reproduce any of this material without written permission from the Author