Stripping out data in a column when sometimes it has no valuable d

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column with full names -i.e. "Mr. George Hanson", however in this
same column some of the data is only "Mr.". I have been able to seperate the
Mr. and the lst name, however whenever I try to run my query for stripping
out the first Name, I can view it, but when I run the query i get multiple
errors because of the ones that are just "Mr." i need an example of somethng
that works - please.
 
Try this to get first name only

Left(Trim(replace([FieldName],"Mr.","")),instr([FieldName]," "))
 
Back
Top