I have a database that is linked to AFD Postcode plus, so when I enter a postcode into a textbox, the rest of the address comes up for a particular area.
I.E. HX1 3PA - would be Lombard Street, Halifax, W Yorks.
I want my query to look at the entered postcode in that text box and extract anything up to and not including the " " value and display it in a seperate column for further querying.
How would this be done in a query.. I'm not familiar with SQL so please if this is the only way to do it, then explain what you are saying...
Thanks in advance you brainy lot!!
Chyld
I.E. HX1 3PA - would be Lombard Street, Halifax, W Yorks.
I want my query to look at the entered postcode in that text box and extract anything up to and not including the " " value and display it in a seperate column for further querying.
How would this be done in a query.. I'm not familiar with SQL so please if this is the only way to do it, then explain what you are saying...
Thanks in advance you brainy lot!!
Chyld