Experience, Knowledge, Creativity

  • Increase font size
  • Default font size
  • Decrease font size

How to Check for the Continental United States

E-mail Print PDF

This information is based on the United States Postal Service standard abbreviations for states and territories:

If your data needs to include addresses for the continental United States only, it's best to check if the address's state is included in the list of continental states, rather than checking if the state is not in the list of non-continental states.

For example, this incorrect SQL snipit allows addresses in Guam and other territories to pass through:

WHERE store.State NOT IN ('AK','HI','VI','PR')

This is the correct code to check for continental United States:

WHERE store.State IN ('AL', 'AZ', 'AR', 'CA', 'CO', 'CT', 'DE', 'DC', 'FL', 'GA', 'ID', 'IL', 'IN', 'IA', 'KS', 'KY', 'LA', 'ME', 'MD', 'MA', 'MI', 'MN', 'MS', 'MO', 'MT', 'NE', 'NV', 'NH', 'NJ', 'NM', 'NY', 'NC', 'ND', 'OH', 'OK', 'OR', 'PA', 'RI', 'SC', 'SD', 'TN', 'TX', 'UT', 'VT', 'VA', 'WA', 'WV', 'WI', 'WY') AND store.Country = 'United States'

Indexes for W3C HTML and CSS Docs

E-mail Print PDF

I just found these great indexes for the W3C HTML and CSS documentation. It uses a frameset with a list of all HTML elements or CSS properties in a frame on the left and the current W3C docs on the right. Very nice. I found them on Paul Parks’ website.

HTML Index:

CSS Index:


How to Create Alerts for SharePoint Groups

E-mail Print PDF

You can't normally create alerts for SharePoint groups. Here's how:

  1. E-mail enable the SharePoint group so that a distribution list/group is created in Active Directory.
  2. Edit the properties of the group to change its Group Type to Security. Only security groups will show up in SharePoint's address book. They will show up as "domain groups" in SharePoint.
  3. Give the domain group at least visitor permissions on the list that are you are creating the alerts for. Alerts won't be sent if the domain group doesn't have appropriate permissions. This will mean that you'll likely have both the SharePoint group and the domain group in the permissions list. Simply giving the SharePoint group permissions is not enough.
  4. Then setup the alert and use the address book to locate the domain group. In the address book you'll see it with the form "DOMAIN\group name".
  5. Now test out your alerts. If you have require approval turned on for the list, make sure you approve the items so alerts will be sent.

How to Tell What Version of SharePoint You Are Running

E-mail Print PDF

Penny Coventry, MVP - How to find the level of SharePoint you are running - Appears to the be the master list of version numbers

System.What? - What Version of SharePoint are you Running? How about your client? - Talk about moving a content database from one sub-version of SharePoint to another


Page 7 of 9

My Twitter Feed


Subscribe by e-mail:

Site Search

Google Ads