Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Count characters to first space

Comment:

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) Thanks

Reply:

For those who may be interested I used the INSTR function which identifies the position of the first space: InStr([Postcode]," ")

0

Database and Software as ...

Talend Integration Suite ...

Summary: In theory all databases are convertible. However, Filemaker Pro has a feature that is difficult to replicate without a lot of work on the application and/or greatly increased file sizes. A record ca...

Summary: Windows sees the first space in your command after "C:\Program " as the end of the command, and everything after it as arguments to the command. Try enclosing the command in quotes, like this: "C:\Pro...

Summary: Hi everybody, I would appreciate some hint to resolve a problem concerning some SQL code that runs without problem in a query design, however using the same code (with exception of inserting concatena...