Select everything left

[Guest]

In Access 2000, what expression could I use in a query in order to select
everything to the left of a special symbol (the forward slash: /) from a text
field, please?

 

[John Spencer]

Field: GetLEft: IIF(SomeField Like
"?/*",LEFT(SomeField,Instr(1,SomeField,"/")-1),SomeField)


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Worked brilliantly. Thanks very much.

Field: GetLEft: IIF(SomeField Like
"?/*",LEFT(SomeField,Instr(1,SomeField,"/")-1),SomeField)


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..