I swear I saw a way to do this but I cannot find it now.
I want to compare Last name, house number, street name, and first letter of first name for two tables.
I am looking to get
Smith, Jeff 301 Anystreet and
Smith, Jeffrey, 301 Anystreet.
I am certain the command is left([fieldname],1) but I am not sure where it goes in the query.
Thanks for the help.
__._,_.___
Posted by: jan.hertzsch@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar