query for everything left (or right) of delimeter

[bravo6]

One of the fields in my table has passenger name in the format lastname/firstname. I need to break this into to two fields in my query results "lastname" and "firstname". How do ask for everything to the left of the "/" and then everything right of it?

This is in Access not SQL.


Thanks

 

[SkipVought]

Hi,

Check out InStr, Left, Right & Len functions

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[bravo6]

No help at all.

 

[SkipVought]

Is this for a query or did you want to modify the table structure/data?

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[lespaul]

What do you mean? Those functions take certain parameters and return everything left or right of what you specify...how could they have been of no help at all?


Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com