how to remove some text part from field in table thru query

[kalaskar pd]

In our database field name conatains Mr. Mrs. Miss ect which we want to remove thru query

Please help me in writing such query

[zmbd]

You need to be exact with your terminology;
Field name = the name of the field in the data table - what you see in the design view of the table.

So, do you need to change the DATA in the table so that you can remove the "Mr, Mrs, Mr., Mrs."

OR

do you need to change the name of the field in the datatable?

[NeoPa]

This is exactly why the design of the tables is so important. It's really easy to add atomic fields together to get the required results. Much less easy to split them up. Don't store information together in a field if you need it separately.

That said, if the data follows certain rules then it can usually be manipulated. To help you manipulate the data we'd need, at the very least, a clear description of any rules you expect the data to follow.