Update Query - Left up to "-" instead of set Number

[shepkrm]

Hello,

I searched through the FAQ's and keyword search, but could not find an answer...

I am attempting to create an update query that takes value from a table that looks like "DATA DATA DATA - data information" and only keep the pieces before the "-". (DATA DATA DATA) There is not a set number of characters before the -.

Has anyone found a function that could complete this task?

I appreciate your help!!
Becky

 

[jadams0173]

"DATA DATA DATA - data information"

It this is data that is in one column have a look at INSTR function. It could be used in combination with the LEFT function to get the data you need.

 

[PWise]

left (DATA DATA DATA - data information,instr("DATA DATA DATA - data information","-")-1)

 

[shepkrm]

Thank you!!!