| array | |
|---|---|
| 1 | C |
| 2 | o |
| 3 | e |
| 4 | u |
| 5 | r |
| 6 | |
| 7 | d |
| 8 | ' |
| 9 | A |
| 10 | l |
| 11 | e |
| 12 | n |
| 13 | e |
| array[empty] |
|---|
| struct | |||||
|---|---|---|---|---|---|
| CACHED | false | ||||
| COLUMNLIST | ZIPCODE | ||||
| EXECUTIONTIME | 28 | ||||
| RECORDCOUNT | 0 | ||||
| SQL | select usps.zipCode from tbl_USPS_CityStateDetails usps where ( usps.citystatename = '%Coeur d''Alene' or usps.preferredLastLineCityStateName = 'Coeur d''Alene%' or usps.preferredLastLineCityStateName = 'Coeur d''Alene' or usps.preferredLastLineCityStateName = ?) and usps.stateabbr = 'ID' and usps.zipClassCode <> 'U' order by cityStateMailingIndicator desc, convert( int, usps.zipCode ) | ||||
| SQLPARAMETERS |
|
||||