roxannep
Technical User
- Jun 20, 2000
- 69
Okay, this one is pretty basic but I'm about out of tries:
I need to have an entry in the field ZipCode of my Players table retrieve the city and state from LU_Zip which contains that information. Problem: The ZipCode field may contain 5 digits, or 9 depending on if we have the +4. The LU_Zip only has the 5 which is all we need to pull city and state.
What is the best way to attack this one? Using a module at the form field ZipCode, setting up a SQL string, but how do I let it know to compare only the first 5 digits (this is a text field).
I need to have an entry in the field ZipCode of my Players table retrieve the city and state from LU_Zip which contains that information. Problem: The ZipCode field may contain 5 digits, or 9 depending on if we have the +4. The LU_Zip only has the 5 which is all we need to pull city and state.
What is the best way to attack this one? Using a module at the form field ZipCode, setting up a SQL string, but how do I let it know to compare only the first 5 digits (this is a text field).
