我有一个独立的 table, called patient infor, it has: first name, last name, DOB, gender and race.
现在我如何 create a field named UIN using expression follow by UIN formula below.
The UIN is a 12 digit number consisting of both letters and numbers. The UIN is created using the following formula:
1st digit: First letter of first name, if unavailable, enter ‘9’
2nd digit: Third letter of first name, if unavailable, enter ‘9’
3rd digit: First letter of last name, if unavailable, enter ‘9’
4th digit: Third letter of last name, if unavailable, enter ‘9’
5th & 6th digits: Month of birth (01 to 12)
7th & 8th digits: Day of birth (01 to 31)
9th & 10th digits: Year of birth (00 to 99), do not use century
11th digit: Gender (Male: 1, Female: 2, Transgender: 3, Unknown: 4)
12th digit: Race/Ethnicity (White/Non Hispanic: 1, Black or African American/Non Hispanic: 2, Hispanic/Latino(a): 3, Asian: 4, Native Hawaiian/Pacific Islander: 5, American Indian or Alaskan Native: 6, Two or more races: 7, Unknown/Unreported: 8
建议你列出你的表结构，并提供测试数据以及基于这些测试数据的所对应正确结果。
参考一下这个贴子的提问方式http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html
1. 你的 create table xxx .. 语句
2. 你的 insert
我用Access数据库做了一个图书数据库，里面有一个字段是ISBN，就是ISBN号，但是只的一总分图书写的ISBN号，有的没写，写的那一部分有的ISBN是重复的，能否用SQL语言把重复的过滤掉，但没写ISBN号的图书不能过滤掉，� ......
