How do I separte Text from the fpost code SW1, S20 and ... ans

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I separate the Text from the first two Characters of the post code
i.e. for SW1 1KP, answer should be SW and for S20 1PU answer should be S.
Help in access or sql
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separate the Text from the first two Characters of the post codes 1
I/O buffering 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How do I find all zip codes from the web? 4
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Change the color of each capital letter in a rich text memo field. 0
Access Command to run access, open to specific form and specific record 1
Macro that will insert a simple text string in top cell of text file 1

Back
Top