Count characters to first space

Dell / Xps 210
September 9, 2009 at 03:36:29
Specs: Vista Home Premium, Intel Dual Core 3Gb
I have a table of postcodes in an access 2007 database and I need to isolate the first part of the postcode. Does anyone here know how I can calculate the number of characters before the first space (or the position of the space itself)


See More: Count characters to first space

Report •

September 9, 2009 at 03:46:52
For those who may be interested I used the INSTR function which identifies the position of the first space:

InStr([Postcode]," ")

Report •
Related Solutions

Ask Question