I am trying to extract text before a certain character appears in a
string. This character is the letter "C".
Here is some sample data - the field is called REFERENCE_2:
REFERENCE_2
10299C17264
9841C17218
I want to extract 10299 for the first line and 9841 for the second
line into a SQL query. I am trying to use the FIND function so I can
get the position of C and do a MID function on this position from the
first character to the position of C - 1, but FIND does not work in
the query builer screen.
I am not proficient with VB and want to use the normal query
functionality.
Many thanks.