query that reads only part of a field

[Jeff Brooks]

I am trying to run a query that will read only up to a certian point of the
record in a field.

I have a field which contains a varying amount of numbers and letters. I
want to read everything prior to a specific instance of letters.

for instance, I could have the following records in my field:
7t3VkHHHH003
8np6HHHH5
5ebgihan44HHHH98

and in my query, I only want to read the text to the left of "HHHH".

Thanks,
Jeff

 

[Rick Brandt]

I am trying to run a query that will read only up to a certian point of the
record in a field.

I have a field which contains a varying amount of numbers and letters. I
want to read everything prior to a specific instance of letters.

for instance, I could have the following records in my field:
7t3VkHHHH003
8np6HHHH5
5ebgihan44HHHH98

and in my query, I only want to read the text to the left of "HHHH".

NewField: Left([OldField], Instr(1, [OldField], "HHHH")-1)