I've searched up and down for the right way to do this and can't figure it out. I have a table with records that look like such:
1 John Doe Houston Texas
2 Adam Dean Reno Nevada
3 Mark Mill Medford Oregon
I want to write a query that will look through my records and return the state abbreviation where the state name currently is. The query could either hard code this information or reference my "State_Abbreviations" table which looks like this:
1 Alabama AL
2 Alaska AK
3 Arizona AZ
4 Arkansas AR
All in all, I would like my final data to look like this:
1 John Doe Houston TX
2 Adam Dean Reno NV
3 Mark Mill Medford OR
Please help with the best way to accomplish this! Thank you!
Sometimes MS breaks things just for fun...
In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset.
Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…