I'd like to pull whatever is to the left of the first space, but it may not always be numeric or text.
I tried using:
LEFT({cm04.CM04_ADD2},INSTR({cm04.CM04_ADD2}," "))
but it doesn't work.
It's really for addresses. Sometimes I will have something like "123 Main St" while other times I may have entries like "36W497 W 83rd St"
All I know is I want everything to the left of that 1st space.