Migrating to the file geodatabase |
|
Release 9.3 |
WHERE clause syntax for a personal geodatabase | Equivalent syntax for a file geodatabase |
---|---|
[STATE_NAME] = 'California' | "STATE_NAME" = 'California' |
[OWNER_NAME] LIKE '?atherine smith' | "OWNER_NAME" LIKE '_atherine smith' |
[STATE_NAME] = 'california' (when a case-insensitive search is required) | LOWER("STATE_NAME") = 'california' |
UCASE([LAST_NAME]) = 'JONES' | UPPER("LAST_NAME") = 'JONES' |
[DATE_OF_BIRTH] = #06-13-2001 19:30:00# | "DATE_OF_BIRTH" = date '2001-06-13 19:30:00' |
SET RENTAL_PRICE = (RENTAL_PRICE - 1.00)